Could you help me to find the good formula to do a perfect match with a Rest Api ?
I got a text output with this form “example1 example2 example3…” and another output with this form “exampleA”.
I would like a If Condition checking if “exampleA” matches perfectly with one of example 1, 2 or 3.
So far, I found this solution : EXACTLY_ONE(SPLIT(“example1 example 2 example3”, " "), item == TRIM_WHITESPACE(exampleA)) but it doesn’t work properly everytime (sometimes exampleA is same as example3 but it’s not accepted anyway).
I can’t use CONTAINS because the output “examp”, for instance, would match with example 1, 2, 3 but I want to check if the output given is the same as one of the items in my list.
Thank you for your response and at your disposal to provide more details.