Mask data with asterisk

MarcosC_

Hi all,

I need to mask some client data on the output file however, searching for this topic I only get annonymzed data / incoherent text. However the goal is for the knowing people to still be able to recognize who the client might be.

What I want is to keep the first letter of the cell followed by 3 asterisks.

So as an example, the cell would be John Smith, Ltd and after the formula the cell should be just J*** for example.

Any ideas on how can I do that?

Thanks,

Marcos

Pilsner

Hello @MarcosC_ 

I may have gone a bit over the top, but if you need the number * to match the number of characters, then you can do the following. 

1) Separate the first character and the remaining characters into separate cells. 

2) Replace all characters in the "remaining" column with *.

3) Append the first character back to the start. The solution looks something like this: 

I've attached the workflow below. 

Please let me know how you get on.

Regards - Pilsner

New Workflow7.yxmd