How to Handle Spaces Correctly When Reading CSV Files with Scanner() in Java?

Read CSV with Scanner()

When reading CSV files using Java's Scanner class, it's crucial to handle spaces correctly. The issue described here, where text with spaces gets moved to the next line, arises from the default behavior of Scanner.

Expected Behavior:

CSV files often contain fields with spaces, such as addresses. When parsed, each field should be captured as a single unit, even if it contains spaces.

Actual Behavior:

By default, Scanner uses whitespace as a delimiter, meaning that it interprets spaces as field separators. Consequently, any text with spaces gets split into multiple fields and placed on separate lines.

Solution:

To resolve this issue, you can use the useDelimiter method of Scanner to specify a different delimiter. Since CSV files typically use commas as field separators, you can use the following code:

<code class="java">Scanner inputStream = new Scanner(file).useDelimiter(",");</code>

This will instruct Scanner to treat commas as field separators, thereby preserving the integrity of fields with spaces.

Example:

Using this corrected code, the CSV data provided in the question will be parsed as follows:

first,last,email,address 1, address 2
john,smith,[email protected],123 St. Street,
Jane,Smith,[email protected],4455 Roger Cir,apt 2

Each field, including those with spaces, will be captured as a single unit, resulting in the desired output.

The above is the detailed content of How to Handle Spaces Correctly When Reading CSV Files with Scanner() in Java?. For more information, please follow other related articles on the PHP Chinese website!