Read CSV with Scanner() Issue

When reading a CSV file using Scanner(), it's common to encounter issues with text containing spaces being moved to the next line. This occurs because Scanner follows whitespace boundaries.

Incorrect CSV Handling in Scanner() Usage

The code snippet provided uses Scanner() to read and process the CSV file. However, it does not correctly handle lines with spaces. For example, in the CSV row "address 1, address 2," the whitespace between "address 1" and the comma causes it to be split into multiple lines.

CSV Parsing Guidelines

When working with CSV files, it's essential to consider the following guidelines:

• Incorrect CSV parsers produce faulty results: Many CSV parsers on the internet implement quoting, escaping, and other aspects incorrectly, leading to incorrect output.
• Use robust CSV libraries: To avoid these issues, utilize well-established CSV libraries like opencsv, Ostermiller Java Utilities, or Apache Commons CSV.
• Follow CSV RFC: If you insist on creating your own parser, carefully study the official RFC for CSV to ensure proper implementation.

In this specific case, the following points highlight the incorrect handling:

• CSV files can contain whitespace between separators and (quoted) values.
• Scanner() splits input based on whitespace boundaries, which is incorrect for CSV parsing.
• To correctly read the CSV file, you should consider using a more appropriate CSV parser library.