How to remove top 4 rows in CSV before i use activity Read CSV

In my project i need only the table with column and corresponding rows below the column. I need to remove first 4 rows from the below screen shot and convert remaining to datatable.

image

Hi,

Can you try to use ReadTextFile, Regex.Replace and GenerateDataTable as the following?

Note: Regex expression is

System.Text.RegularExpressions.Regex.Replace(yourString,"^(.*\n){4}","")

Regards,

Hi Yoichi,

I tried above step but i did not get the desired output in table. the table contain no value. Attaching the csv file and the xlam file for reference.

i want to remove the first 4 rows and have only table from row 5.

Thanks
Sureshbabu.RProcessing: test.csv…
Sequence.zip (1.9 KB)

Hi,

Can you try to set variable in ReadTextFile activity then use it in Regex.Replace as the following.

Regards,

1 Like

Hi Yoichi,

This worked and thanks a lot for your timely solution. Really appreciated!!!

Regards
Sureshbabu.R

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.