Discussion board where members can get started with QlikView.
I have a requirement of replacing a String Field Substring.
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.
Go to Solution.
Try: left([Input Row], 2) & repeat('x', len([Input Row]) - 4) & right([Input Row], 2)
=mid('AEJGASHDFN2K',1,2) & REPEAT('x', len('AEJGASHDFN2K')-4) &
Put this in a text box and test.