split problem

[mac]

I have a file that contains 2 lines:

Jerry|Seinfeld|Seinfeld |Seinfeld
Elaine|Benes|Benes|Benes {1 space after Benes}

I am reading file into a List<String> b and then getting index 0,1 rows and splitting them by "|" to get values in each columns

String[] a = b.get(0).split("\\|");

I am recognizing that row 0, column 2 contains a space in "Seinfeld "
String[] a = b.get(0).split("\\|");
a[2] has a space

I am failing to recognize that row 1, column 3 contains a space after "Benes "
String[] a = b.get(1).split("\\|");
a[3] does not have a space (BUT IT REALLY DOES)

Please point me in the right direction

After testing various cases, i came to a conclusion that only LAST column is affected.

thanks

[Lil_Aziz1]

you have to do split("\\\\|")

4 \\\\ because \\ is = to one \ in java. since \ is a literal character in regular expression, you need \\ in regex. if \ regex char == \\ java, \\\\ java == \\ regex

[mac]

Hang on ... but why does split works fine for all columns but last?

String[] currentRows = makeHTMLFromOutDotTxt.get(row).split("\\|");
System.out.println("." + currentRows[3]+".");


this print always shows no spaces after the field, where in reality there are some

[mac]

Again, to be crystal clear: my file is delimited by |, any amount of white space is also included between |.

[mac]

While i still would very much to hear an answer to my question, i have solved the problem

If i am adding | at the very last column (after space), i am now able to split accurately