Parsing CSV file using ExcelCSVParser
Hi All!
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.
|