Data issue with sequencial file

prasson_ibm · Post by **prasson_ibm** » Mon May 25, 2009 11:39 pm

Hi all,
I am extracting sequencial file of comma seperated and quote character is double quote.But there are some junk characters in the one of the columns.I want this junk character to be removed or can be rejected to track the records.If you have any idea ,how to handle this ,please let tell me.
Regards
Prasoon Kumar

mahadev.v · Post by **mahadev.v** » Mon May 25, 2009 11:48 pm

See if this post helps. viewtopic.php?t=113640

prasson_ibm · Post by **prasson_ibm** » Tue May 26, 2009 1:49 am

mahadev.v wrote:See if this post helps. viewtopic.php?t=113640

Thanks this has helped me and i have resolved my issue with junk character/......

ray.wurlod · Post by **ray.wurlod** » Tue May 26, 2009 4:20 pm

prasson_ibm · Post by **prasson_ibm** » Tue May 26, 2009 11:12 pm

ray.wurlod wrote:How? ...

Hi Ray,
There was some junk character in my source file,so i have used piped the source file with tr command and with tr -d option i have deleted that junk characher.............

ray.wurlod · Post by **ray.wurlod** » Wed May 27, 2009 12:50 am

Then you have deprived the owners of those data of some of their data.

On whose authority were those characters declared to be "junk"? Did you get agreement from the business to delete them? Who, in the organization, is the data steward with responsibility for this item of data?