Menu
I am parsing a file of data whose fields are separated by pipes. The records are separated by newlines. This is similar to a CSV file or even a TSV file (http://www.cs.tut.fi/~jkorpela/TSV.html), but I wonder what the accepted file extension for pipe delimited data is?
I do not see one specifically mentioned in http://en.wikipedia.org/wiki/Delimiter-separated_values and I have not found mention of one in the 5 or so StackOverflow questions I referenced.
The WP article suggests to me that, by way of "extension" from comma to CSV and tab to TSV, the extension should be PSV. Not everyone calls a pipe a pipe though.
Maybe there is a popular software package that uses pipe delimited data and has an extension for it, thereby setting the de facto standard?
352
DESCRIPTION OF COMMA-DELIMITED FILE csv extension) that contains a pipe (“|”) delimited file. The most important feature of this . csv file is that for rows 14 – 23, the third column is actually a pipe-delimited file. In this example, there are 10 columns (_1 to _10) in the pipe-delimited file.
Exporting Excel Files as Pipe Delimited To save the file as Delimited, you'll need to click the Office button and choose Save As –> Other Formats. Then select CSV (Comma delimited)(*. csv) from the drop-down list, and give it a name.
General information about Flat FilesFields within each file are separated by the vertical bar character (“|”) commonly referred to as a “pipe”. A null or missing value for a field is delineated by consecutive “pipes” in the data stream. Records within each file are delimited by the line feed (LF) character.
I had this same question because I wanted to follow the standard if there was any. The obvious choice here is .psv considering the naming system of .csv and .tsv - however, I couldn't find this in use anywhere.
The most common extension that I could find associated with a pipe-delimited file is simply .txt. Exports from census.gov and most other government entities use .txt for pipe-delimited files.
96
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
