Adding characters for specific count

rsdhavle — Mon, 02 Apr 2018 08:41:50 GMT

I have a client field which has multiple value. The requirement is I need to add '*' character in the middle as in need to mask those value.

So lets say my client name is ABCDE I need to show it as A***E. I need to insert 3 '*' here

If I have calculated count where I need to insert * values based on the requirement how can I insert those number of * characters in client name value for different counts like 3,4,5,6 etc

Re: Adding characters for specific count

tresB — Mon, 02 Apr 2018 08:57:59 GMT

If you want to always keep the first and last letters and replace rest, try like:

=Left(<YourString>, 1) & Repeat('*', <count>) & Right(<YourString>, 1)

topic Adding characters for specific count in QlikView

Adding characters for specific count

Re: Adding characters for specific count