Java Scanner reading something that is not there when reading CSV file

Question

I have a csv file that goes like this

Mike,Smith
Scuba,Steve
John,Doe

And java code that goes like this:

Scanner file=new Scanner(new File("input.txt"));

file.useDelimiter(",");      
while (file.hasNext()){

   String s1=file.next();
   String s2=file.next();
   System.out.println(s1+" "+s2);

}
file.close();

I get as output:

Mike Smith
Scuba
Steve
John Doe

I don't understand what could possibly make this work on the first two names but not the middle one

aioobe · Accepted Answer · 2015-02-25 16:44:12Z

5

This is because Smith\nScuba becomes one token. (There's no , separating them.)

Using

file.useDelimiter(",|\n");

solves the problem.

If you happen to be using Java 8, I'd recommend using something like:

Files.lines(Paths.get("input.txt"))
     .forEach(line -> {
         Scanner s = new Scanner(line);
         s.useDelimiter(",");
         System.out.println(s.next() + " " + s.next());
     });

edited Feb 25, 2015 at 16:44

answered Feb 25, 2015 at 16:37

aioobe

423k115 gold badges831 silver badges844 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Boris the Spider Over a year ago

It seems easier just to use String.split at that point. Spawning loads of Scanners isn't fast...

aioobe Over a year ago

If split does the job, then sure. Since the OP was using Scanner, I thought that maybe his actual code was a bit more complicated. Regardless, the best approach is probably to use a CSV library, so that stuff like a,"b,c",d is handled correctly as well.

Collectives™ on Stack Overflow

Java Scanner reading something that is not there when reading CSV file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related