Filter DataTable Column and Extract part of the String

[Tiago_Dias]

Hi all,
I have a datatable with the columns “Title” and “Creation Date”.
First I need to filter by creation date = previous day and then count the nr of lines for each company code.

To obtain the company code, I need to extract part of the text, in the title column, as follows:
EMAIL LTR VAT ID - Complete LTR-document 7859154 / BUK= 0510 LF=BIRD & BIRD LLP

The BUK= XXX is the company code and so I need to count all the lines/items with BUK= 0510, in this example.

Anyone can help me?

[Srini84 (Srinivas)]

@Tiago_Dias

filter by creation date

@Tiago_Dias

Check below thread for Date filter

Filter Datatable contains datetime

Hi, I have an excel sheet where Robot Start Date column is in General format. Its supposed to contains values in datetime format MM/dd/yyyy HH:mm:ss I would like to filter the datatable to create a second datatable for rows which have the same date MM/dd/yyyy I’ve tried Dt.Select(“[Robot Start Date] LIKE ‘%MM/dd/yyyy%’”).copytodatatable and it says cannot perform operand LIKE on system.string and system.datetime I cannot use filter datatable activity because it is not a table in the Excel sh…

you can use Filter Datatable an write the column as “Title” Contains “BUK=510”

Hope this will help you

Thanks

[Tiago_Dias]

Hi.
I tried that but the thing is that the datatable will have multiple company codes on the column title (company code = buk) and so I need a way to split and extract the buk and then count the number of lines for each buk and considering the initial filter of creating date = previous day(yesterday)

Let me know how to solve this.
Thank you,
Tiago Dias

[Jobin_Joy]

Hi @Tiago_Dias

You can filter the data table in multiple ways. The below reference will be definitely helpful.

Four Ways to Filter Data Tables in UiPath Studio | UiPath

To extract the part of a string, either you can use ‘SubString’ or ‘RegEx’.

Thank you.