DSXchange

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.

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

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

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

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?