Yeah....
I've had my own problems with InStr. You really have to be sure what your data is going to look like... and it has no exceptions either like ignoring stuff you don't want to look at like items in quotes or brackets or whatever.
I've written various versions of my own and used stuff from Chip Pearsons site as well.
For this problem.. given a sentence... I'd suggest removing punctuation, Split to get the words and loop through the array to test for specific things using StrComp with an option to ignore case if needed. It won't be quick though.. I think Split is relatively slow.
Lisa
Sent: Wed, Aug 22, 2012 2:42 pm
Subject: [ExcelVBA] Re: specfic character pick
I agree that InStr is working. I'm thinking that for each find of the root word,
a look at the chars immediately proceeding and following the find, while
checking for end of file and "before the file" (don't know what the common
terminology for that is), will be required.
Dave G
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar