How to copy exact 50 lines of code from a file when a timestamp is there

[mukesh_behera]

Hi, I have a text file in that text file I want to copy starting from a timestamp to 50 lines of code.
may consider the time stamp format is—[2020-11-27]. I will not copy the data before the timestamp.

Thank you in advance…

[Mulya_Habibi_Tullah]

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

Filter data based on Year

Hi @som17 Below is the workflow for the same :- MainPratik.xaml (10.3 KB) Output :- [image] [image] [image] Mark as solution and like it Happy Automation Best Regards Er Pratik Wavhal

[jack.chan]

you can use regular expression, for example in the image above, i capture the first 20 lines after the first “[2020-11-27]” that is detected

You can use it in uiPath by assigning the following to a string
System.Text.RegularExpressions.Regex.Match(logText, "\[2020-11-27\] (.*\n){20}").Groups(0).Value

[mukesh_behera]

Thank you so much, you save my day.

[mukesh_behera]

Hi, would you please tell me I want to select text from a particular text till pattern then can I do this, like I want to get text from [2020-12-17] to a pattern similar to this.
Would you please help me to build the regular expression

[mukesh_behera]

Waiting for your response.

[jack.chan]

can you be more specific? you want the text from [2020-12-17] to what text?

[mukesh_behera]

Consider from [2020-12-17] to [2020-12-16]

[jack.chan]

im on my phone but heres a rough regex, im sure it can be improved. This captures text from the first [2020-12-17] to the last [2020-12-16]. Is this what you want?

\[2020-12-17\] (.*\n)+\[2020-12-16\].*\n

[mukesh_behera]

Thank you so much. This is working. Thanks a lot.

[mukesh_behera]

Your expressions are really helping, One thing more As I can see in the screenshot that expression selects till last occurrance of the [2020-12-16], if i need it to only select from [2020-12-17] till the first occurrance of the [2020-12-16] than how Can I do this?
Please help…
Thanks in advance.
Waiting for your response…

[jack.chan]

@jack.chan

[2020-12-17] (.\n)+[2020-12-16].\n

you can use the regex
(\[2020-12-17\] (.*\n)+?)\[2020-12-16\]

and capture group 1 instead of group 0 (meaning in UiPath you use .Groups(1).Value instead of .Groups(0).Value

Again this regex can be improved, as i did this in a rush but hope it helps

[mukesh_behera]

Thanks a lot. Your suggestions are really helpful.