Skip to Content
Former Member
Nov 09, 2007 at 10:45 PM

Help with a string search


Ok, I need syntax when I am merging tables.

I need to search a particular field and do some logic against it.

For example, field A1 could say "i have no idea how to code this problem" and I would have to search for a BEGINNING phrase "i have no idea..."

If found, A1 = B1 (a different field).

Could someone post syntax on how to search for a phrase within a field?

Would you use the search?

If so, then what would the if statement look like?