Dear All,
Please help me with the formula to mask the text.
Below is the sample input and required sample output
Input Output
A1234567X Axxxx567X
Thank you in advance
Hi @Ekta ,
Do all the records have the same length (the given example has a length of 9 characters) and do you want to replace characters 2-5 with x in all strings?
If yes, the following formula will get the job done
Replace([Field1],
Substring([Field1],1,4),"xxxx")
Hope that helps,
Angelos
@Ekta
It will better you could provide more sample data.
Another solution would be to go and check if the field you want to mask has the format of an uppercase letter, followed by some digits and closing with an uppercase letter. If that's the case then you want to replace the 4 digits after the first uppercase character, else throw an error message.
A lot of different ways to go about it, it largely depends on your use case here.
Regards,
Angelos