I am trying to find a substring in a string and return the value 1 if it finds it.
Example.
(Contains([Vendor/supplying plant], "ABC", 1)
OR
(Contains([Vendor/supplying plant], "DEF", 1)
OR
Contains([Vendor/supplying plant], "GHI", 1))
then 1
ABC Logistics Returns 1 but it also picks other values Such as
dataabc1234 Returns 1 as well.
I just want value to be set as 1 only when ABC or ABC is an exclusive word and not a substring in another string.
Please suggest.
Solved! Go to Solution.
Try this:
(Contains(" "+[Vendor/supplying plant]+" ", " ABC ", 1)
Added spaces to the beginning and end of both string and substring.
@Christina_H awesome thank you.