Forum Discussion
efilipe
Helper IV
Helper IVIf 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)
MarcelBeug
Community Champion
Community Championibarrau I guess Power Query is far less limitated then you might expect... :smileywink:
efilipeHelper IV
Helper IVNice Marcel! The other response was not a solution for me because, as I said, the problem was really more complex. Thank you!