Publication Date – October 27, 2018
If a spreadsheet processor software (such as Microsoft® Excel) is generating multiple or double commas, ensure the file is correctly parsed:
- Double-click the file or select Open with to open the file.
- Select Text-to-Columns in the “Data context” menu. The selection will open a wizard panel.
- In the wizard panel, select Delimited.
- “Comma” as the delimiter.
- “Quotes” as the text qualifier.