I want to convert the pipe delimitated text file into an XML file and then parse it. The file has a field where there occurs a pipe inside the single field enclosed by inverted commas..for example A|B|"C|D|E"|F.I was using the LabeledCSVParser before till i knew about this anomaly of pipes within a single field.
Now, previously in the XML file, i was accessing the label easily using getValueByLabel(LabelName) method of LabeledCSVParser. Now, how can i access the labels using ExcelCSVParser.
Any idea would be highly appreciated.
This shouldn't be a problem, given that quoted fields containing non-special delimiter characters are such a basic part of the CSV format, but I suppose there could be a bug the Ostermiller CSV utils. You might try one of the other Java CSV tools out there: