Quote character within a quoted text field
Posted: Fri Oct 23, 2009 6:30 am
Hi ,
I've got a comma separated file with character fields quoted with "s.
I've found some records where there is a section within a character field that is quoted with 2 double quotes.
e.g.
1,"some field1","some field with a ""quoted section"" in it",2
This seems to cause my datastage to assume that its a new field when it sees the "" characters.
Anyone got any ideas how I should handle that ?
Why does datastage treat the " character as though it signifies a new field ( when the file is using comma as the delimiter).?
I've got a comma separated file with character fields quoted with "s.
I've found some records where there is a section within a character field that is quoted with 2 double quotes.
e.g.
1,"some field1","some field with a ""quoted section"" in it",2
This seems to cause my datastage to assume that its a new field when it sees the "" characters.
Anyone got any ideas how I should handle that ?
Why does datastage treat the " character as though it signifies a new field ( when the file is using comma as the delimiter).?