data with double quote

dnat · Post by **dnat** » Thu May 07, 2009 1:11 am

Hi
I have a job where the input file format is
Delimiter |
Quote double.

But i got one record like this

"aaaaa"|"bbbbbbbb"|"cccccccccc""|"ddddddd"

Now this record is getting rejected because of the extra double quote in "ccccccc".
is there a way to handle this.

yousuff1710 · Post by **yousuff1710** » Thu May 07, 2009 2:33 am

You canot read the data in this format; you need to remove that extra double quote.

ray.wurlod · Post by **ray.wurlod** » Thu May 07, 2009 4:45 pm

The file is "corrupted". Get whoever created it to use a different quote character (or none) around strings.

datastage_learner · Post by **datastage_learner** » Thu May 07, 2009 10:33 pm

dnat...master...can't you use any unix / shell script to remove and clean quotations issue... that should be fairly resolve it

ray.wurlod · Post by **ray.wurlod** » Thu May 07, 2009 11:40 pm

It's a difficult problem to solve generically - it's easy if the extraneous double-quote character is at either end of the string, but what if it's in the middle?