Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the accepted file extension to use for pipe delimited files?

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?

like image 352
David Mann Avatar asked Oct 26 '11 15:10

David Mann


People also ask

Can a CSV file have pipe delimited?

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.

How do I make a CSV file a pipe delimited?

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.

What is pipe delimited flat file?

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.


1 Answers

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.

like image 96
leek Avatar answered Sep 22 '22 07:09

leek