Forum Discussion
How to remove characters from string
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
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"})
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
PhilipTreacy perfect, that worked. Many thanks.
Vijay_A_Verma - issue fixed
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"})Vijay_A_Verma even better, thanks for that. Appreciate it:)