Hi

I have a CSV file that I wish to parse.

A typical line will look like this:

3,,"04-0501",-13000.00,,000,"DE","ATA","","","MR AJ & MRS BJ
SMITH","08/03/2004",04 0501

so I was using String[] statementElements = statementLine.split(","); to
break up each line into the individual elements.

BUT then I found a line like:

3,,"04-0501",-13119.75,,000,"DE","ATA","JONES,SA&DB","FI ZEBBO","ABC
SECURITIES(NZ)","08/03/2004",04 0501

Note the "JONES,SA&DB" though :-(  So split will break that where I do not
want it to do so.

Any ideas or references that would help?

Thanks
Shane