How to replace first 4 digit with # in chart or scipt

[Naps_230]

Hi Everyone,

I have requirement like to convert first 4 digit into '#' .

EX:- 

I/P	O/P
1234567	####567
5456990	####990
6789076	####076

[marcus_sommer · Accepted solution]

Maybe: '####' & mid([I/P], 5)

- Marcus

[Stoyan_Terziev · Accepted solution]

Hi Jash,

Here you go:

Switch:
LOAD
[I/P] as [I/P],
'####'&Right([I/P], LEN([I/P])-4) as [O/P]
;
Load * INLINE [
I/P
11315155
25145156
3141556
441431516
531313155
63123156643
];

[Taoufiq_Zarra · Accepted solution]

maye be :

'####'&right([I/P],len([I/P])-4) as [O/P],