How to remove characters from string

[qsmith83]

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

[PhilipTreacy · Accepted solution]

Hi @qsmith83 

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

[Vijay_A_Verma]

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 -?

[PhilipTreacy · Accepted solution]

Hi @qsmith83 

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

[qsmith83]

@PhilipTreacy perfect, that worked. Many thanks.

@Vijay_A_Verma - issue fixed

[Vijay_A_Verma · Accepted solution]

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"})

[qsmith83]

@Vijay_A_Verma even better, thanks for that. Appreciate it:)