How To Filter table row, and string reduction value

[AaronMark]

Hi to all,
I need to scrape a table, and then filter the columns.
Of these, I need to cut a partial string, but it doesn’t seem to work, with the FILTER DATA TABLE activity.
These are the two columns.

Column1	Column4
Service/Time Sheets #69742	PO 0410118263

So, how did I setup the activities:

but using this setting, the first two columns disappear in table B.

…and I also need to know if there is also a way to do logic on another cell.
Column 14 contains a string plus, optionally a text field, always “none”, or a date.

ex1. Column14
Actual CompletionNone
ex2: Column14
Actual Completion2023-04-26

I wish it could understand if after the string “Actual Completion” there is a date, then it collects the date, otherwise the string “none”.
Is it possible to always do this in the Filter Data Table activity?

Is there a way to do it all in one step?
Thanks A lot…

[Jithesh_R (Jithesh Karkera)]

@AaronMark ,
If you are having less rows in your data table you can loop through it as shown below

Regards,

[Anil_G (Anil Gorthi)]

@AaronMark

1. In filter datatable columns tab is used to remove or retain columns but not to modify the data of the column
2. If you need to filter rows then use rows tab
3. If you need to so any manipulatiosn on data then either use For each row in datatable and perform manipulations inside or use Expressions Eg: dt.Columns("ColumnName").Expression = "SUBSTRING([ColumnName], 1, 5)"

Hope this helps

cheers

[AaronMark]

two answers, both very helpful.
I select the first chronological as a solution, but the aids are both invaluable!
A thousand thanks.

[AaronMark]

Jithesh_R
what string did you use to define the Column1Value?
This: Right(CurrentRow(“Column1”,5)) gives me an error.

[Anil_G (Anil Gorthi)]

@AaronMark

Right(CurrentRow(“Column1”).Tostring,5)

Cheers

[Jithesh_R (Jithesh Karkera)]

@AaronMark ,
Column1Value is a “String” type variable Please check the Brackets.

Right(CurrentRow(“Column1”).Tostring,5)

Regards,