SAP BODS 3.1 csv delimiter issue
I have requirement for the below issue facing on SAP BODS XI 3.1
Eg: I have one .csv file for the below format:
separated by comma, and I need to extract only 5 columns in BODS, file format is not proper for comma separated
i.e..,first row contains 7 columns
second row contains 9 columns
While creating file format, by default it’s create maximum columns fields in file format,
after file format, I have created query transform to map only 5 columns.
When I executed the BODS job throwing an error that “A row delimiter was seen for row number <1> while processing column number <7> in file”.
Could you please suggest that, how can I resolve this kind of files in .csv format.
Please help on ASAP.