serach for a particular word

cherry · Post by **cherry** » Fri Aug 28, 2009 5:36 am

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

ArndW · Post by **ArndW** » Fri Aug 28, 2009 5:40 am

Code: Select all

Index(In.Column,"BANK",1)

will return a 0 if "BANK" is not in the string, otherwise the location of the first occurence of "BANK" in the string.

chulett · Post by **chulett** » Fri Aug 28, 2009 5:43 am

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:

Code: Select all

Index(" ":YourField:" ", " BANK ", 1)

That will match BANK (even at the ends) but not, mmm... BANKRUPTCY, which it would normally for a pure substring search.

cherry · Post by **cherry** » Fri Aug 28, 2009 9:12 am

Thanks for all the Support. Its working

Regards
Cherry