How can I have export data delimited by Pipes instead of commas?

When data is exported from a spreadsheet to a CSV (Comma Separated Value) file, and then opened in NotePad or any text editor, each cell is separated by a comma.  Some clients would prefer that each cell be separated by a pipe '|' instead  of the comma.
The easiest option is usually to open the document in any text editor and do a Find and Replace, and replace all commas with a pipe.  These are usually the only commas in the document so there is not too much danger of replacing a grammatically necessary comma.

Environment

 Team Approach
 RSR
 TA

Was this article helpful?