mask the middle number using the sort



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

mask the middle number using the sort

Postby thotlma » Mon Oct 15, 2018 9:23 pm

Hi ALL

i have requrement like this. could you please help any one help me?

i have 16 digit length fileld in my input file. if more than 13 digit length then first 4 digit as it is and last 4 digits as it is and mask the remaining the number
if less than 13 then keep the number as it is.

example
IP file


0000359681243354  
0000359681243354  
810176733  
     

OP


0000........3354  
0000........3354  
810176733
 


the code tags... the flucking code tags
or have your posts deleted
thotlma
 
Posts: 14
Joined: Tue Sep 18, 2018 8:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: mask the middle number using the sort

 

Re: mask the middle number using the sort

Postby NicC » Tue Oct 16, 2018 9:46 am

Test for byte 14 being non-blank. If it is then overlay the required bytes with the required mask.
And use data sets, not files.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2820
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 118 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post