Shulou(Shulou.com)06/01 Report--

This article shows you how to use the CSV format, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

CSV, or Comma Separate Values, is a plain text format used to store data. This file format is often used as a format for data exchange between different programs. The final file can be opened in a spreadsheet program such as Microsoft Excel, or it can be used as an import format for other programs.

CSV file format

Each record occupies one line (but if there is a newline character in the field, one line becomes multiple lines)

Use a comma as a separator

Spaces before and after commas are ignored

The field contains a comma and must be enclosed in double quotation marks

The field contains line breaks, which must be enclosed in double quotation marks

The field contains spaces before and after the field, which must be enclosed in double quotes

Double quotation marks in a field are indicated by two double quotation marks

If there are double quotation marks in the field, the field must be enclosed in double quotation marks

The first record, which can be a field name

PS opens the file in Excel. If the field starts with 0, the preceding 0 will be removed automatically. Add the equal sign and it will display normally. (= "00001"), but remember to use excel only. There is no equal sign for data import.

The above is how to use the CSV format. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.