Hi, I'm having an issue finding a word in a text field which looks like below:
'NXP54661 A Finance',
'NAP54661 X Finance',
I needed to create another field to show whether 'X' appears in the text field as a single word rather than a letter of a word. in the two shown above, the first should come as False, while the second should come as True. I tried a couple of string functions, but none gave me desired result. For example Index function will count the first as True which is not what I wanted. any help is much appreciated. Thanks.