Unable to read CSV file

Hi,

Can you try as the following?

First, read csv file as string using ReadTextFile activity.
Next remove the first line of the string using the following expression.

strCsv = System.Text.RegularExpressions.Regex.Replace(strCsv,"^.*\n","")

Finally, convert it to DataTable using GenerateDataTable activity with CSV option.

Regards,

1 Like