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.
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.