Forum Discussion
Solved
If text doesn't contain character
Hi, I know this work for me, but I also want to check if the text doesnt contain a character: if (Text.Contains([DATE], "/") and Text.Length([DATE])=10) The date field is very messed up wi...
Text.Contains does return true or false already (and you are using it in your formula).
You can reverse the ouput by putting "not " (lower case) in front of it, like in
if (not Text.Contains([DATE], "/") and Text.Length([DATE])=10)
ibarrau I guess Power Query is far less limitated then you might expect... :smileywink:
Nice Marcel! The other response was not a solution for me because, as I said, the problem was really more complex. Thank you!