Replacing substring with Some Character

[Pulkit_Thukral]

Hi ,

I have a requirement of replacing a String Field Substring.

Example.

Input Row - "AEJGASHDFN2K"

I want Output as - "AExxxxxxxxx2K"

I just want First 2 letters and last 2 letters to be shown ,rest all "X".

NOTE: The length of string would be dynamic. hence cannot set hard coded values.

[marcus_sommer · Accepted solution]

Try: left([Input Row], 2) & repeat('x', len([Input Row]) - 4) & right([Input Row], 2)

- Marcus

[#3]

=mid('AEJGASHDFN2K',1,2) & REPEAT('x', len('AEJGASHDFN2K')-4) &

right('AEJGASHDFN2K',2)

Put this in a text box and test.