java scanner 读取文件,Java - 使用Scanner读取CSV（）

My csv is getting read into the System.out, but I've noticed that any text with a space gets moved into the next line (as a return \n)

Here's how my csv starts:

first,last,email,address 1, address 2

john,smith,blah@blah.com,123 St. Street,

Jane,Smith,blech@blech.com,4455 Roger Cir,apt 2

After running my app, any cell with a space (address 1), gets thrown onto the next line.

import java.io.File;

import java.io.FileNotFoundException;

import java.util.Scanner;

public class main {

public static void main(String[] args) {

// -define .csv file in app

String fileNameDefined = "uploadedcsv/employees.csv";

// -File class needed to turn stringName to actual file

File file = new File(fileNameDefined);

try{

// -read from filePooped with Scanner class

Scanner inputStream = new Scanner(file);

// hashNext() loops line-by-line

while(inputStream.hasNext()){

//read single line, put in string

String data = inputStream.next();

System.out.println(data + "***");

}

// after loop, close scanner

inputStream.close();

}catch (FileNotFoundException e){

e.printStackTrace();

}

}

}

So here's the result in the console:

first,last,email,address

1,address

2

john,smith,blah@blah.com,123

St.

Street,

Jane,Smith,blech@blech.com,4455

Roger

Cir,apt

2

Am I using Scanner incorrectly?

解决方案

scanner.useDelimiter(",");

This should work.

import java.io.File;

import java.io.FileNotFoundException;

import java.util.Scanner;

public class TestScanner {

public static void main(String[] args) throws FileNotFoundException {

Scanner scanner = new Scanner(new File("/Users/pankaj/abc.csv"));

scanner.useDelimiter(",");

while(scanner.hasNext()){

System.out.print(scanner.next()+"|");

}

scanner.close();

}

}

For CSV File:

a,b,c d,e

1,2,3 4,5

X,Y,Z A,B

Output is:

a|b|c d|e

1|2|3 4|5

X|Y|Z A|B|