Parsing comma delimited text in Java

Question

If I have an ArrayList that has lines of data that could look like:

bob,      jones,    123-333-1111
    james, lee,  234-333-2222

How do I delete the extra whitespace and get the same data back? I thought you could maybe spit the string by "," and then use trim(), but I didn't know what the syntax of that would be or how to implement that, assuming that is an ok way to do it because I'd want to put each field in an array. So in this case have a [2][3] array, and then put it back in the ArrayList after removing the whitespace. But that seems like a funny way to do it, and not scaleable if my list changed, like having an email on the end. Any thoughts? Thanks.

Edit: Dumber question, so I'm still not sure how I can process the data, because I can't do this right:

for (String s : myList) {
    String st[] = s.split(",\\s*");
}

since st[] will lose scope after the foreach loop. And if I declare String st[] beforehand, I wouldn't know how big to create my array right? Thanks.

Answer 1

You could just scan through the entire string and build a new string, skipping any whitespace that occurs after a comma. This would be more efficient than splitting and rejoining. Something like this should work:

String str = /* your original string from the array */;
StringBuilder sb = new StringBuilder();
boolean skip = true;

for (int i = 0; i < str.length(); i++) {
  char ch = str.charAt(i);

  if (skip && Character.isWhitespace(ch))
    continue;

  sb.append(ch);

  if (ch == ',')
    skip = true;
  else
    skip = false;
}

String result = sb.toString();

Answer 2

If you use a regex for you split, you can specify, a comma followed by optional whitespace (which includes spaces and tabs just in case).

String[] fields = mystring.split(",\\s*");

Depending on whether you want to parse each line separately or not you may first want to create an array split on a line return

String[] lines = mystring.split("\\n");