How Import CSV file and load into CDT(without database)

The Excel Tools plug-in contains a function, "previewCSVForImport()", which should allow you to read CSV contents into local data and parse as you will.

Thanks Mike Schmitt, But this has limitation to parse only 1000 rows. I want to parse around 2500 records.

This sort of detail needs to be mentioned up-front then.

Hemant Borate said:

I want to parse around 2500 records.

The only alternative I can think to suggest is that you convert your CSV into an Excel file, and then use the "readExcelSheetPaging()" function, and read paged sets.

You could try using https://community.appian.com/b/appmarket/posts/text-file-reader. Basically load the csv file, split it into an array based on carriage return.

a!localVariables(
  local!items: split(
    readtextfromfile(cons!S_CSV_DOCUMENT, true),
    char(10)
  ),
  a!forEach(
    items: local!items,
    expression: split(fv!item, ",")
  )
)

Mathieu Drouin said:

Basically load the csv file, split it into an array based on carriage return.

And pray none of the data columns contain escaped commas... (though the parse CSV row function might help with this, otherwise it'll be a nightmare)