I want to check if a variable contains a letter. For this I want to use a formula in a prepare recipe
Here my code :
Output is always '2' even when there is a letter in the variable i'm checking
Thank you, Olivier
My impression from the documentation is that arrayContains doesn't work with regular expressions, which is what you are trying to do apparently.
What might work is this:
if(arrayLen(match(column, ".*([A-Za-z])")) > 0, 1, 2)
where you should replace column with the name of your column of interest.
If I understood your problem wrongly please let me know! Cheers
Thanks a lot Ignacio !
it works with just a little adjustment. Indeed, ".*" is missing
the final working formula is "if(arrayLen(match(column, ".*([A-Za-z]).*")) > 0, 1, 2)"
Thanks again for your reactivity, Olivier