I have a a Sequential file where the records are delimited by comma(,) and double quote.
There is a record like this in the data file:-
"1111111","aa aa aa","""xxxxxx""","nnnnn"
But when i read this record in the sequential file , it is getting rejected. i think this is because of more than one double quote enclosed for the field "xxxx". But i would like to process this record as there are equal number of start and end quotes. Is there a way to process this.
Thanks
double quote in sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If there are no double-quote characters in the data, then use a Filter command to get rid of them. The tr -d \" command would be fairly efficient.
You could also set the Quote Character property to None, which would mean that the quote characters become ordinary data, but could be removed subsequently with a Trim() function.
You could also set the Quote Character property to None, which would mean that the quote characters become ordinary data, but could be removed subsequently with a Trim() function.
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.