Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you want to always keep the first and last letters and replace rest, try like:
=Left(<YourString>, 1) & Repeat('*', <count>) & Right(<YourString>, 1)
If you want to always keep the first and last letters and replace rest, try like:
=Left(<YourString>, 1) & Repeat('*', <count>) & Right(<YourString>, 1)