AnsweredAssumed Answered

Comma in a CSV file

Question asked by ragu.subramaniam on Nov 30, 2016
Latest reply on Dec 1, 2016 by ashwini_ambatipudi1

I have a flat file in CSV format, certain columns may have comma in it, in those cases the column values are enclosed in double quotes. For Ex: "Florida, Inc". I created a flat file profile to load it and cache it. Then, I read records from DB, convert into a new flat file(CSV format) in a map, in the map I look up the cached CSV file. The resultant flat file looks good when the looked up record don't have commas, the columns are jumbled and a column missing when the looked up record has a comma part of the data. Could someone help me with this? In the cached flat file profile options, I selected comma delimited and no other option.