What is Delimited Text File first?
1. A delimited text file is one in which each line of text is a record, and the fields are separated by a known character.
2. Common delimiters include the tab character or various punctuation characters. The delimiter shoshould always be one which does not appear in the data.
3. delimited text files are easily produced by most desktop spreadsheet and database applications (eg Microsoft Excel, Microsoft Access ). you can usually choose "File" then "Save As" or "Export", then select the type of file you wowould like to save.
That is, each row of the file is a record, and each column of the record is separated by special characters (usually punctuation ). Existing table tool software generally supports such files.
Let's look at the previous Pipe.
Here Pipe refers to Pipe Symbol, which is the vertical line Symbol "| ". So this is actually a text record file that uses vertical lines as separators. Do you think CSV is exactly the same? The separator is different.