Remove Junk in a file

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

Hi Frds,

I have struck up with an issue.
I have an input file.In that file i have field of X(12).It may contain junk characters starting from any place.It means if contains 5 chars data then the remaining(From 6th position) may be junk r low values.if it contains data of 9 chars the from 10th position there may be junk.Now i need to change that to spaces.

Can any one help me on this.

acevedo · Active User Joined: 11 May 2005 Posts: 344 Location: Spain

Removing unwanted characters in a field using SORT

murmohk1 · Posted: Tue Mar 04, 2008 1:21 pm

Sri,

Remember the JUNK for you, may be NOT junk for others (atleast for MF).

How will you idenfity the JUNK? any condition?

Anuj Dhawan · Posted: Tue Mar 04, 2008 1:24 pm

Hi,

When do You call something as "'junk", this needs to be undetstood. Define Your rules for junk data or best please share some sample records from input & show the expected output. We might come up with desired solution.

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

Here Junk i mean is other than numeric,alphabetic and special chars.

murmohk1 · Posted: Tue Mar 04, 2008 2:44 pm

Sri,

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India