Name field encrypt part

[Anonymous]

I have a name field and I want i to keep the same number of chacters but replace everything with '*' except for the first character.

e.g.

Name = 'Smith'  - Encrypted Name = 'S***'

Name = 'Johnson' - Encrypted name = J******

Is there any script that will do this?

Thanks

Phil

[Gysbert_Wassenaar · Accepted solution]

Left(Name,1) & repeat('*', len(Name)-1) as Name

[Anonymous]

Perfect.

Thanks

Phil

[Anonymous]

As a further q is there any way I can put the last character on there aswell

E.g.  J*****n

[Anonymous]

modify Gysbert's expression to do it:

Left(Name,1) & repeat('*', len(Name)-2) & right(Name,1) as Name

[Anonymous]

It's better define a maximum size: (in this case 60)

Left(Name,1) & repeat('*', 58) & right(Name,1) as Name