Search found 1 match
- Wed Apr 06, 2011 1:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading CSV(array data in "") and creating an XML
- Replies: 1
- Views: 955
Reading CSV(array data in "") and creating an XML
In some cases I have, the CSV has comma separated values in one column e.g. "ColumnAValue1","ColumnBValue1,ColumnBValue2,ColumnBValue3","ColumnCValue1,ColumnCValue2" is one row of the CSV file. This has to be converted to XML as <ColumnA>ColumnAValue1</ColumnA> <ColumnB...