2 Replies Latest reply: Aug 20, 2007 11:56 PM by 807605 RSS

    Parsing CSV file using ExcelCSVParser

    807605
      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.