Remove junk characters by keeping the 'good' characters



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

Remove junk characters by keeping the 'good' characters

Postby simantor » Wed Feb 25, 2015 10:54 am

Hi,

I want to remove junk characters keeping the good characters.

Below characters in the file that I want to retain ( and maintain the same column position ) -

'A' through 'Z'
'a' through 'z'
0 through 9
Special characters like `~!@#$%^&*()_-+=\|:";'{}[]?/>.<,

2. Want to remove junk characters like X'AD', X'00', X'15' etc. from the record and replace EACH of them with space ( X'40').

Please help me with an easy solution for this.
simantor
 
Posts: 1
Joined: Wed Feb 25, 2015 10:46 am
Has thanked: 0 time
Been thanked: 0 time

Re: Remove junk characters by keeping the 'good' characters

Postby Aki88 » Wed Feb 25, 2015 11:59 am

Hello,

Maybe it is just me, or this request is actually similar to the one here, see if it helps you, the query asked is almost exactly same.

Regards.
Aki88
 
Posts: 381
Joined: Tue Jan 28, 2014 1:52 pm
Has thanked: 33 times
Been thanked: 36 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post