… and other custom-char delimited files.
Presented below is a screenshot-based tutorial on how to change the character used to separate data pieces within what’s called a List.
As soon as you are finished, you can SAVE your CSV file and it will follow this system setting and save the file using the character you’re using. If you chose a pipe character (it looks like this: | ), your csv file data will be separated by a pipe and this is great for data that is comma-inclusive.
If you’re separating by pipe, you can rename the file to carry the extension “.psv” which is used by CVSer to locate pipe-delimited files. It is absolutely necessary step until custom characters are accepted into CSVer.
Here’s the text from the source in case the page ever goes down:
– username thomach on the ozgrid,com forum supplied this helpful tip!
If you need Export Excel data to a CSV file but the data have commas in it, you can in Windows change the delimiter used in the export from outside of Excel — specifally via the Control Panel.
Go to the Control Panel –> Regional and Language Options (or Date, Time and Regional Options –> Regional and Language Option on some machines) –> click the Customize button. In the dialog box that opens you will see and option for “List separator” in which you can change the comma to a different character –> click Apply then Ok and then Apply again. Now when you go into Excel and choose Export as CSV the new character will be used as the delimiter.
If you liked this article, or have feedback, your thoughts and feedback are welcome – comment below, use the Contact page, or connect via Twitter.