I am trying to mask a string with asterisks (*) except the first character.
Input: India, Output: I****
Input: Australia, Output: A********
I tried the below RPAD expression but it is throwing the "RPAD: Operand Not Constant Error" for the Length function--
RPad(Substr(CountryName, 1, 1),Length(CountryName),'*')
Can you please help
SUBSTR(RPad(Substr(Country, 1, 1),100,'*'),1,LENGTH(Country))
I do not think any country name has more then hundred chars but if it does you can up the 100. It does not matter since we are substr the field. I tested and it is working fine on my side.