Java read csv problem

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

?
Apr.01,2021

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 |
Menu