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.
- Select:
- “Comma” as the delimiter.
- “Quotes” as the text qualifier.
Other Methods
Publication Date – October 27, 2018
Feedback
0 comments
Please sign in to leave a comment.