topic Re: Replacing substring with Some Character in QlikView

Replacing substring with Some Character

Pulkit_Thukral — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 18 Jul 2016 05:46:09 GMT

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

- Marcus

Mon, 18 Jul 2016 05:47:53 GMT

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

right('AEJGASHDFN2K',2)

Put this in a text box and test.