If text doesn't contain character

[efilipe]

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 with many variations. So I also need to check, like the example above, if there's if no character in the field. Like "Text.DoesnContain". Is there maybe a way to detect if Text.Contain is true or false, maybe?

Thank you.

[MarcelBeug · Accepted solution]

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]

@ibarrau I guess Power Query is far less limitated then you might expect...

[efilipe]

Nice Marcel! The other response was not a solution for me because, as I said, the problem was really more complex. Thank you!

[ibarrau]

The thing with power query is that it is limitated. I think you don't need to ask about doesn't contain, just go to false in contains.

E.g:

if Text.Contains([DATE], "/") then

if Text.Length([DATE])=10 then "both true"

else "here is different to than 10"

else  "here doesn't contain"

Hope this helps.

P/D Blank and null can be treated with button transformations.