double quote in sequential file
Posted: Mon Sep 24, 2007 4:38 am
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
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