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.
How do I remove special characters from a text in a column? Can I do it by using 'Replace values' or do I have to create a custom column? I tried using replace values [""] with blank but that didn't work.
Appreciate any help
Solved! Go to Solution.
Hi @Anonymous
If you want to remove [""] then you need to treat these as different characters if they appear in a string as shown in your image.
So do Replace values 3 times, once for each character.
Regards
Phil
Proud to be a Super User!
Great.....Just a single statement is needed. No need to do replacement 3 times. In below, replace Source with your previous step and Data with your column name.
= Table.ReplaceValue(Source,each [Data],each Text.Remove([Data],{"[","]",""""}),Replacer.ReplaceValue,{"Data"})
What is the result expected from the replacement which you want to make? Do you want to replace only quotes, brackets or also comma and -?
Hi @Anonymous
If you want to remove [""] then you need to treat these as different characters if they appear in a string as shown in your image.
So do Replace values 3 times, once for each character.
Regards
Phil
Proud to be a Super User!
Great.....Just a single statement is needed. No need to do replacement 3 times. In below, replace Source with your previous step and Data with your column name.
= Table.ReplaceValue(Source,each [Data],each Text.Remove([Data],{"[","]",""""}),Replacer.ReplaceValue,{"Data"})
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.