Page 1 of 1

Remove junk characters by keeping the 'good' characters

PostPosted: Wed Feb 25, 2015 10:54 am
by simantor
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.

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

PostPosted: Wed Feb 25, 2015 11:59 am
by Aki88
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.