|
View previous topic :: View next topic
|
| Author |
Message |
rajatbagga
Active User
Joined: 11 Mar 2007
Posts: 199
Location: india
|
|
|
|
Hello Guys,
I need to mask a variable size field (min 10 bytes, max 19 bytes) as per my sample input and output data below
Input data
| Code: |
1348701373183741089
438748760387351370
1938491384
13453413413313
634133434123
32313134132
7129481974199149
|
Output data
| Code: |
1348XXXXXXXXXX1089
4387XXXXXXXXX1370
1938XX1384
1345XXXXXX3313
6341XXXX4123
3231XXX4132
7129XXXXXXXX9149
|
Masking Rules - Only the first and last 4 bytes of the field should be visible while the remaining (in-between) bytes should be be masked with X
Please help me with some ideas on how i can achieve this using sort.
Thank you. Rajat |
|
| Back to top |
|
 |
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1350
Location: Bamberg, Germany
|
|
|
|
| Code: |
OPTION COPY
ALTSEQ CODE=(F0E7,F1E7,F2E7,F3E7,F4E7,F5E7,F6E7,F7E7,F8E7,F9E7)
INREC IFTHEN=(WHEN=INIT,
OVERLAY=(5:5,15,JFY=(SHIFT=RIGHT),5:5,11,TRAN=ALTSEQ,
1:1,19,SQZ=(SHIFT=LEFT)))
END |
|
|
| Back to top |
|
|
rajatbagga
Active User
Joined: 11 Mar 2007
Posts: 199
Location: india
|
|
|
|
| Joerg.Findeisen wrote: |
| Code: |
OPTION COPY
ALTSEQ CODE=(F0E7,F1E7,F2E7,F3E7,F4E7,F5E7,F6E7,F7E7,F8E7,F9E7)
INREC IFTHEN=(WHEN=INIT,
OVERLAY=(5:5,15,JFY=(SHIFT=RIGHT),5:5,11,TRAN=ALTSEQ,
1:1,19,SQZ=(SHIFT=LEFT)))
END |
|
Fantastic - Thank you !! |
|
| Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1350
Location: Bamberg, Germany
|
|
|
|
| Pleasure. Thanks for feedback, and also for providing input in the right format to work with. |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2157
Location: USA
|
|
|
|
In this simple case, even IFTHEN parameter is not required:
| Code: |
OPTION COPY
ALTSEQ CODE=(F0E7,F1E7,F2E7,F3E7,F4E7,F5E7,F6E7,F7E7,F8E7,F9E7)
INREC OVERLAY=(5:5,15,JFY=(SHIFT=RIGHT),
5:5,11,TRAN=ALTSEQ,
1:1,19,SQZ=(SHIFT=LEFT))
END |
|
|
| Back to top |
|
|
|
|
|
