Page 1 of 1

delimiter reading

Posted: Tue Sep 05, 2006 3:08 am
by parvathi
Hi all

I have a problem while reading with delimiters... in the sequential stage

the record is as below

QuoteChar "\""

In this case i have the delimiter as "

so first column value is QuoteChar
second column value is \
third column value is null

but i want to have second column value as \"


How can I do that...?? Do i need to set anything

Posted: Tue Sep 05, 2006 3:21 am
by ArndW
You cannot solve your problem with the quote character defined as a ".
This is because the line is not well-formed due to unbalanced quotes. You will need to specify another quote character or delimiter to avoid this.