Copying elements from a csv file into a data table using filter wizard

Hello, I am trying to copy elements from a column in a csv file if the row in the column has exactly 12 characters into a data table. For example if the row in that column had 12 characters then I would like to copy that element into the data table and if not then skip that row and continue on to the next row in that column. I would like to try doing this in filter wizard if possible.

Thank you in advance for your help!

we would suggest following alternate flow:

read csv - read csv data into a datatable - dtData
filter the data with the help of a linq statement

assign activity:
left side: dtDataFiltered
right side:

(from d in dtData.AsEnumerable
Where d(YourColNameOrIndex).toString.Length = 12
Select d).CopyToDataTable

(we assume that at least one row will pass the filter, otherwise we would handle the empty result as well)

Optional: modify afterwards the columnstructre e.g. with the help of filter datatable activity

Thank you for the help! It worked.

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