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

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

minseok_kr — Thu, 27 Jun 2024 00:49:21 GMT

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?

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

ibarrau — Thu, 27 Jun 2024 13:34:16 GMT

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

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

v-cboorla-msft — Mon, 01 Jul 2024 05:58:58 GMT

Hi minseok_kr

Thank you.

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

v-cboorla-msft — Tue, 02 Jul 2024 07:03:00 GMT

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.