| |
A delimited text file is a method of representing a table of data in a text file using characters to indicate a structure of columns and rows. This is typically used to provide an import/export function for services, software and databases that represents data in a neutral format. The following are common types of delimited text file.
Comma-separated values (CSV)The use of commas to separate fields. The end of each row is indicated with a newline character. Often given the file extension ".csv". In some cases, semicolons are used at the end of a row as opposed to a newline character. It is common to place data that includes commas in double quotes and to use an escape sequence when data includes a double quote.
Tab-separated values (TSV) The use of tab characters to separate fields and newline to indicate a new row. Common in regions where commas are used as decimals in numbers making commas an extremely bad choice as a delimiter. Tab characters are rarely used in data.OtherCommas are common in data and tabs characters look much like spaces creating a sense of ambiguity for human editing. As such, it is common to use any character that isn't common in data to delimit files. For example, the pipe character "|" is a common choice to delimit fields.
Computing
This is the complete list of articles we have written about computing.
If you enjoyed this page, please consider bookmarking Simplicable.
Examples of computing in everyday life.
Binary completely explained.
An overview of hexadecimal as it relates to computing.
The difference between application software and services.
A definition of data processing with examples.
The common types of virtual machine.
A definition of system on a chip with examples.
The definition of embedded system with examples.
A definition of real-time with examples.
An overview of data with a list of examples.
The basic types of data.
The definition of dark data with examples.
Several useful definitions of data.
A definition of analytics with examples.
The difference between data and information.
The difference between hard data and soft data.
A definition of human readable.
The common types of data loss.
TrendingThe most popular articles on Simplicable in the past day.
Recent posts or updates on Simplicable.
Site Map
© 2010-2023 Simplicable. All Rights Reserved. Reproduction of materials found on this site, in any form, without explicit permission is prohibited.
View credits & copyrights or citation information for this page.
|