C # get CSV file contents for comma and quote-delimited processing

We know that there are several rules when you save a CSV file using the Excel tool:

1. Separate the cell contents of each row with a comma.

2, if the contents of the cell itself has a comma, the contents of this cell will be enclosed in quotation marks.

3. If the contents of the cell itself have quotation marks,

The quotation marks are not in the first or the end, and the cell contents are not enclosed in quotation marks.

The quotation marks are at the beginning or end, and the cell contents are enclosed in quotation marks and the original and trailing quotes are escaped.

C # get CSV file contents for comma and quote-delimited processing