Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Convert text files to CSV format for analysis' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Convert text files to CSV format for analysis
Authored by: mrmkirsch on Sep 22, '09 08:57:59AM

In CSV format, strings that contain embedded commas must be surrounded by double quotation marks. Failing to do that will cause embedded commas to be interpreted as extra fields.

As others have mentioned already, most spreadsheet programs are capable of importing tab-delimited files without the need for conversion to CSV format.



[ Reply to This | # ]