Compare text in columns

[MikeS81]

Hi pickslide5,

to use the same StringX array as now you can use the "Format Into String" function before compare the strings. Therefore you could create a new array with strings like this:

%s, %s., -%s, (%s), ... and create the new string inside the for loop.

Mike

[smercurio_fc]

You don't really need to get that complicated. Use the regex code of "\b" to match a word boundary. Example:



In the above example if you set offset to 0 then "foot" is found at index=8. If you set offset to, say, 9, to search after the word "foot", then no match is found. I.e., there is no match against "footwell" or "footsy".


Message Edited by smercurio_fc on 03-17-2008 10:09 AM

[pickslide5]

This looks great - I have just now managed to get the thing to work with a massive great big array of every conceivable combination of: -foot foot, (foot- etc...

It took about 20 minutes to run through with my largest dataset!

I'll give this version a try - it looks a lot neater!

Many thanks!