hy can you help me that how to skip some rows from csv files
in loop i am reading all csv files from folder but in strarting of every scv file there were extra data so how skip these
we can read the csv into a datatable and then use take/skip on the resulting data rows
also we can use take/skip on the text lines when reading the csv text file as text by
Assign Activity
arrLines | DataType: String Array =
File.ReadAllLines(“YourFullPathToCSVFile”)
Can you provide more details,
How you are defining which are rows are extra.
you can use filter data table activity, there you can filter the data to remove the extra columns what you are thinking. in that activity you need to provide a column names and the values along with condition which was not equal or doesnot contais. based on your requirement
Two ways
- Read the csv into datatable and then use skip function remove rows but in this the header willneeds to be updated as the first row might not be the header in csv
- Read the csv as a text file into a string and then using split and skip or only split function remove the extra data at start and then use generate datatable fromtext to generate a datatable as needed
Cheers