csv reads out a line separated by English and sign. If there is an English comma in a certain box, and I want to get the value of a certain box, then it is not complete. What should I do with
?csv reads out a line separated by English and sign. If there is an English comma in a certain box, and I want to get the value of a certain box, then it is not complete. What should I do with
? you can't handle it in principle. A csv is a text file with characters separated by commas.
if you really need to deal with this kind of data, it is recommended to use other formats such as xslx
it is recommended that you directly use the relevant class libraries to deal with it. For example, apache common has a csv utility class, which will help you with the parsing of these contents.
in principle, if your csv contains ,
, then you should use quotation marks "
$ echo -e 'col1,col2,col3\ncol2-1,col2- 2,"col2,3"' | csvlook
| col1 | col2 | col3 |
| ------ | ------- | ------ |
| col2-1 | col2- 2 | col2,3 |
Previous: Learn how to read local environment variables and environment variables on the server by shell
Next: How to set data values dynamically by echarts in Mini Program