peter_sjogarde
Board Regular
- Joined
- Feb 13, 2012
- Messages
- 56
I am looking for a way to search for words in text without truncating the search (which I automatically do if using instr). The script needs to be reasonably fast since I have about 3*50000 cells to search in and about 500 search terms. So far I have been using
But sometimes I have search terms that I want to hit only if they stand alone (delimited with a blank or something like ,;.: or in begginging/end of cell). Eg. "LCA":
"I want to hit this cell contents about Life Cycle Assessment, LCA"
"I do not want to hit this cell contents about vuLCAnos"
How can i do this?
Code:
If InStr(UCase(title(j, 1)), UCase(searchWords(i, 1))) > 0 ThenBut sometimes I have search terms that I want to hit only if they stand alone (delimited with a blank or something like ,;.: or in begginging/end of cell). Eg. "LCA":
"I want to hit this cell contents about Life Cycle Assessment, LCA"
"I do not want to hit this cell contents about vuLCAnos"
How can i do this?
