|I will work with what you have provided and see what I can get. this is a great start.|
I haven't figured out exactly what I want the output to look like, I needed the functions first.
the data is a single column of essentially random, alphanumeric strings of varying length, separated by spaces (or whatever I replace spaces with). between 1 and 20 words per row, say 150 chars max length, average of 4000 rows in a dataset, max maybe 40000. (chances are these functions will run slow on data this big, that's ok)
#1 will be run multiple times from a list of keywords. I think I will need to use an excel sheet with the terms to search in column A, and then the other columns used somehow to define which t parameters for each keyword. its basically an extension of the macro you helped me with a year ago that I linked thread to. instead of returning the whole row, its going to return the t variables, but im not sure yet how to format the output to be usable.
#2 will be run only one time on a given data set, and return an exponentially large output, which I will analyze as a whole. the purpose is to count occurrences of given relationships (combos). I should probably have prefaced everything with this, but I have data analysis software for performing calculations and searches on the resulting datasets we are creating, so that is why the goal is to create large outputs to then analyze, as opposed to just performing analysis in place and returning counts, etc.
it might be best if it was like, an input box with radio buttons to select the options:
eg #1) - will get back to u, I have an idea for this.
eg #2) -2 words, 3 words, 4 words etc and u push the buttons for how many u want.
the only saving grace for me on this is that its for me, so it doesn't need to be terribly user friendly, if I have to edit some sheets manually or bits of code each time I run it, its not a big deal. if I can get it working, I can design a better way to use it later.
once I have had a chance to work with the data a bit I should have a clear concept of how the output should behave and I will post back here with my progress.
thanks so much for your help :)