Forum Discussion
Solved
Find characters in a string
Is there a way to search for special characters in a string like below "#*&%$£!^+;:?<>" I want to say if it finds any of them its "Invalid"
Hi jak8282
In Power Query create a Custom Column with this
if List.ContainsAny(Text.ToList([String]),Text.ToList("#*&%$£!^+;:?<>")) then "Invalid" else "Valid"Regards
Phil
Hi jak8282
In Power Query create a Custom Column with this
if List.ContainsAny(Text.ToList([String]),Text.ToList("#*&%$£!^+;:?<>")) then "Invalid" else "Valid"
Regards
Phil
Thanks Phil - thats great