Pipe delimited text file download

The text file you will download consists of multiple record types. The content of each record type is pipe-delimited a " " character separates each field. The processing time will depend on the number of your search results - more results will need more processing time and the resulting files will be very large.

Contact tech support if you have questions. The Federal Communications Commission the Commission makes remote software available for public use. The Commission makes no warranty whatsoever with respect to the use of any remote software. In no event shall the Commission, its officers, employees or agents, be liable for any damages whatsoever including, but not limited to, loss of business profits, business interruption, loss of business information, or any other loss arising out of or relating to the existence, furnishing, functioning or use of any remote Commission software.

To save an Excel workbook as a pipe delimited file, please do as follows. Open the Control Panel on your computer. In the Control Panel window, please select Category from the View by drop-down list, then click the Clock, Language, and Region option as below screenshot shown.

See screenshot:. In the Region or Region and Language dialog box, click the Additional Settings… button as below screenshot shown.

Then the Customize Format dialog box is opening. Then a prompt box pops up, please click the OK button. Now current worksheet is converted to a pipe delimited file. If you want to save all sheets as pipe delimited files, please repeat the above step 6 to 8 to save them individually using a different file name for each.

Then you can see values are separated by pipe delimiter as below screenshot shown. Note: The other languages of the website are Google-translated. Back to English. Log in. Tips are provided for SAS and R software. Connect Download Learn Shared Data. Records within each file are delimited by the line feed LF character. The first row of each file contains a delimited list of field names and the order of these names indicates the order of the data fields in the flat file.

Most fields are character and are not enclosed within quotes, although single or double quotes may appear embedded within many of the descriptive fields. To prevent software from interpreting the embedded pipe as a delimiter, the entire string containing the pipe has been enclosed in double quotes. Also,line feed and paragraph break characters within fields, which might otherwise be interpreted as end of record characters, have been removed from the flat file database extracts.