Hi All,
I have a field that contains value AAAAAAA BANK OF SA
I will come to know that the particular value is a BANK Name if it has BANK word in that value. How can I search the value to know that it is a BANK. Is thera any function to like FIND to search for a particular word in the value. Please let me know
Thanks in advance..,
Regards
Cherry
serach for a particular word
Moderators: chulett, rschirm, roy
Code: Select all
Index(In.Column,"BANK",1)
Index() will find it. Simple trick to match the whole word is to concatenate your delimiter to each end of both the string to search and the string to search for:
That will match BANK (even at the ends) but not, mmm... BANKRUPTCY, which it would normally for a pure substring search.
Code: Select all
Index(" ":YourField:" ", " BANK ", 1)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers