Searching for a word

Question

Hi Is there a way to find a word within a word? Such as this: Himynameissaphiroth and find the word name in that word. Thank you

saphiroth42 · Answer

Thank you for the help

joy.simpson · Answer

Use the InStr() function. Example: ival = InStr(Himynameissaphiroth name) ival will return the location of the first character in the 1st string that matches the 2nd string. If not found will return 0. In the above case ival will equal 5. Any non-zero value means the word was found.