Multiple delimiters in Scanner class of Java

Question

How do I use the useDelimiter() method of the Scanner class to use both the comma (,) and the new line character (\n) as delimiters?

I am parsing some text from a csv file.

score 27 · Answer 1 · answered Feb 04 '11 at 13:07

27

 Scanner s = new Scanner("hello, world \n hello world");
 s.useDelimiter(",|\\n");
 while(s.hasNext()){
          System.out.println(s.next());

 }

Output

hello
 world 
 hello world

JavaDoc

answered Feb 04 '11 at 13:07

jmj

237,923
42
401
438

score 8 · Answer 2 · answered Feb 04 '11 at 13:06

8

How about useDelimiter(",|\\n");

answered Feb 04 '11 at 13:06

Andrew White

52,720
19
113
137

4

It escapes the second \. Regex use \n to mean newline but so does Java so you write \\n which gets translated to \n for the regex. – Andrew White Feb 04 '11 at 14:35
Wonder why tomejuan didn't respond. Maybe "escapes", "regex", or the explanation about the second '\'. – DSlomer64 Jan 03 '18 at 01:39

score 2 · Answer 3 · answered Feb 04 '11 at 13:07

2

useDelimiter takes a regex pattern, so, it would be something like ",|\n"

answered Feb 04 '11 at 13:07

adrianboimvaser

2,651
1
22
30

score 2 · Answer 4 · edited Jun 28 '20 at 23:42

2

My text file has entries like:

01-jan-2020,102
02-jan-2020,103
…

To read the two values from each row, it worked with the following, since each line end was having both \r and \n characters:

Scanner.useDelimiter(",|\\r\\n")

edited Jun 28 '20 at 23:42

Jeremy Caney

7,102
69
48
77

answered Jun 28 '20 at 21:24

Rajneesh Gupta

21
1

score 0 · Answer 5 · answered May 10 '17 at 22:46

0

Jigar is absolutely correct. But if it doesn't work, try ",|\\r"

since most text files have \r\n instead of just \n

answered May 10 '17 at 22:46

Orange

1

score 0 · Answer 6 · answered Jul 28 '17 at 16:56

Using Scan Delimiters for Excel files - don't overlook the RegEx thing. In my case the excel file is delimitedby '|'. I have been spending significant time to parse rows using scanner.useDelimiter("|"), and got back character by character. Replacing that with scanner.useDelimiter("\\|") has solved my issue!

Multiple delimiters in Scanner class of Java

6 Answers6

Linked