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.
data with double quote
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 56
- Joined: Fri Sep 21, 2007 9:10 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 15
- Joined: Thu May 07, 2009 9:50 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.