i am creating a csv file with 10 fields and selected the field defaults Quote = double. But when i am generating the file, the quotes are missing in the out put for few fields. especially it is missing for one filed which is a 'COMMENT' field and the comment field has some ',' (comma) in the data. as the double quotes are missing the comment field is spreaded to the next columns.
Are you certain that the data type is "string" for this column; I've never seen this stage not create double quotes when set to do so, but this option only applies to non-numeric fields.
nope, the job is just a oracle enterprise stage, transformer and sequential stage..its a direct move and i didn't set any properties except the format tab with row delimiter string dos prompt.
Go to the stage, double-click the number next to the column name and see if any of those settings are set, that is what I meant by the "extended attributes"
And just to be sure... your delimiter is set to the comma?
Try changing your delimiter and see if it handles the field differently. Can't say I've ever seen this issue (although rarely use comma as my delimiter)