BIX extract in CSV format is showing comma separated values (within double quotes) in new column while opening CSV file in Excel app. Any one has any recommendation on how to avoid it ?
Snapshot of CSV file, showing values in double quotes -
Snapshot of CSV file, showing comma separated value getting split into new column -
Specify the command line delimiters. Please check this post. CSV BIX extract format issue for comma(,) separated values
Hello @RameshSangili , thankyou for your response. Suggested article has options to change a separator but we are having problem with excel not recognizing double quotes around text to consider it as one string and not read separators between double quotes.
@MOHITMITTAL This looks more like an Excel CSV import behaviour than a BIX extract issue. A CSV value that contains commas should be enclosed in double quotes, and the embedded quotes should be escaped properly. If Excel is still splitting the field into new columns when the file is opened directly, the safer approach is to import the file using Data → From Text/CSV and explicitly choose the delimiter and text qualifier
If you have control over the extract format, another practical workaround is to use a different delimiter such as semicolon or tab for the extract, especially when the file is meant to be consumed in Excel. In general, the CSV may be valid, but Excel’s automatic open behaviour can still parse it differently depending on locale and import method.
