Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there a way to search for special characters in a string like below
Solved! Go to Solution.
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
Proud to be a Super User!
Hi @jak8282
If my answer worked for you please mark it as the answer so that others can benefit from learning how to solve this problem.
regards
Phil
Proud to be a Super User!
Hello @jak8282 answer provided by @PhilipTreacy is the best way.
There is another method as well.. which is create a table with all special characters as below:
Then in the actual table create a column using below DAX:
Check =
IF(
SUMX('Special Characters Table',FIND('Special Characters Table'[Characters],'Table'[Column],,0))>0,"Invalid","Valid")
Output looks like this:
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
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
Proud to be a Super User!
Thanks Phil - thats great
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |