Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to figure out a way in order to identify a specific word within a string. The string that is loaded is a variable lenght string and within that string it contains a country name. I am trying to script out some code to check if a specific country name exists. I have tried to play around with the functions but I am unable to make it work. Any ideas anyone?
Many thanks.
Roberto
You could try Wildmatch:
Flag:
If(Wildmatch(Field,'*Country*'),1,0) as Flag
Result:
If(Wildmatch(Field,'*Country*'),Field) as Result
You could try Wildmatch:
Flag:
If(Wildmatch(Field,'*Country*'),1,0) as Flag
Result:
If(Wildmatch(Field,'*Country*'),Field) as Result
Exellent, Thank you very much that worked.
regards,
Roberto