Thursday, March 19, 2015

CSV Escapes

Today I learned that if you are exporting the results of a SQL query to a .csv file to open in Excel, and certain fields may contain newlines, the correct way to make it import correctly is to ensure that your escape character is ".  It took much experimenting to realize this. The more you know.

No comments:

Post a Comment