2 Replies Latest reply on Aug 21, 2007 6:56 AM by 807605

    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.