Instr is good for quick fixes, if your strings are BIG or you need to use it often, you better convert the string to an array and then use a filter to find the value
So
dim temp, aTemp temp="alpha,bravo,charlie" aTemp = split(temp,",") aFound = Filter(aTemp , "alpha") ' aFound (0) contains "alpha" or is an empty array if not found.
Grtz
peter source share