Thursday, September 20, 2012

excel, open csv file using space not comma as a delimiter



In default,Miscrosoft EXCEL only uses comma as a delimiter to open a csv file. If you want to open a CSV file using space as a delimiter in EXCEL, adding
sep=
at the top of your csv file will solve the problem.

No comments:

Post a Comment