topic Name field encrypt part in QlikView

Name field encrypt part

Anonymous — Wed, 25 Feb 2015 14:49:53 GMT

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 — Wed, 25 Feb 2015 14:55:48 GMT

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

Anonymous — Wed, 25 Feb 2015 15:00:46 GMT

Perfect.

Thanks

Phil

Anonymous — Wed, 25 Feb 2015 15:02:14 GMT

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

E.g. J*****n

Anonymous — Wed, 25 Feb 2015 15:11:35 GMT

modify Gysbert's expression to do it:

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

Anonymous — Wed, 25 Feb 2015 19:41:10 GMT

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

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