I want to change a specific digit to '*' among the data in a field that is in character format.

[minseok_kr]

hello. I am planning to conduct new work in Korea through Data Factory and Customer Insights-data.

I am writing because I have a question.

I would like to change personal information in text format (name, cell phone, email, etc.) to the special character '*'.

It can be easily solved with SQL queries, but it is very difficult with Data Flow Gen2.

How do I use functions in Power Query?

[ibarrau · Accepted solution]

Hi. If you want to replace the personal data to "*". You can do it with a simple "custom step" that can be run with right click to column then "replace values".

Let's see an example. Consider  you have the "Name" column that you want to change to *. The code would be:

= Table.ReplaceValue(#"Last Step", each [Name],"*",Replacer.ReplaceValue,{"Name"})

 You can click at the function icon to create a new one or when you replace values just write * to replace. The code will have a "" for the first step that you can change to each [Name]

I hope that helps

[v-cboorla-msft]

Hi @minseok_kr 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thank you.

[v-cboorla-msft]

Hi @minseok_kr 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. If you have any question relating to the current thread, please do let us know and we will try out best to help you. In case if you have any other question on a different issue, we request you to open a new thread.

Thank you.