Import CSV files with dynamic columns each row - Urgent RRS feed

  • Question

  • Hi All:

    I had a problem on importing data from CSV file.

    Since the data provider did not follow the rule on the formats of CSV that created rows with two different columns, let's say:

    type 1 rows: 10 columns

    type 2 rows: 15 columns

    rather than put 14 "," on type 1 rows, they only put 9 and make the end of Column10 nothing. So can anybody help me on importing the data like this? I am on an urgent job so if there is anyone can give me a hand that will be really appreciated.



    Saturday, April 14, 2012 4:49 PM


All replies