3 of 3 people found this helpful
You can do this with string calculations. I've done this in 2 steps.
1 - create a calculated field containing the first 2 characters, then a space for each character in the middle, then the last 2 characters
2. Then replace the spaces in that string, with *
Which will give you the output below - note a 4 letter word has no * in it
Of course if you don't care about the length of the masked field matching your original field, then you can just do something like
LEFT([City],2) + '*****' + RIGHT([City],2)
PS - I have moved this thread into the main Forums part of the site (Forums ), where it will attract more attention. The area you've posted into, is for questions relating to how to use the forum itself.
1 of 1 people found this helpful
Hi Mohit - I notice you marked my response as helpful. Thank you. Did it give you what you need? If so, then please mark the answer as correct, so the thread can be closed down, and it will help others looking for similar responses. If not, please elaborate on why it doesn't meet your needs.
The solution which you have provided is exactly same as I wanted. It's really helpful response.