Looking for a value that contains some unique characters and changing of them

[Anonymous]

Hi everyone,

I have a dataset and I want to change some columns. Some of the values contains different value. For example in a text, there is "Ğ" but I wanna change it as a "G" but not in just one word in a whole column. Do you have any suggestions? 

For example; İf in my column There is any " Ý " I want to replace with "İ". 

[Anonymous · Accepted solution]

Hi everyone, I did it. In the data transform section, I choose a columns that contain values and click replace values 

Value to find --Ý

Replace with-- İ

and in the advanced options i chose "replace using special characters" section. 

[amitchandak]

@Anonymous , I think removing is easy

https://community.powerbi.com/t5/Desktop/Removing-special-characters-and-symbols-from-a-column/m-p/796836

https://xlncad.com/remove-or-extract-special-characters-from-a-data-set-using-power-query/

for replace you have to use replace with from and to character (Power query replace)

[Anonymous]

@amitchandak Hi, Thanks for sharing your opinion but It does not helpful for me. If I do this, My dataset will not be good and meaningful