How can I remove specific lines with dates over 30 days past due, a .txt file in UiPath?

Help Studio
, ,
1

I want to remove all lines with current datetime -30 days, in my .txt file.

“2023-01-01 10:41:32”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE” “2023-02-01 12:40:02”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE” “2022-01-03 09:11:02”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE” “2022-11-01 02:11:05”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE” “2023-02-01 05:55:32”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE” “2023-02-05 12:41:21”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE” “2022-12-18 18:00:00”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE” “2022-01-29 11:22:00”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE” “2022-01-31 12:00:00”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE”

when I save it I should only have those lines left:

“2023-02-01 12:40:02”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE” “2023-02-01 05:55:32”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE” “2023-02-05 12:41:21”;“AAAAAAA”;“BBBBBB”;“CCCCCC”;“DDDDDDD”;“XXXXXX”;“FFFFFFF”;“EEEEEEE”

First I tried to copy to a CSV file, and it works fine. But I’m stuck when I want to filter the dates. Any help?

2

Hi @Woodson_Louis ,

Can you try the following?

After you copied it to CSV file, try to use Read CSV activity, then after we will filter the datatable on the last 30 days:

If your hour format is “h”:
dtCSV = dt_CSV.AsEnumerable.Where(function(r) DateTime.ParseExact(r(“Date”).toString, “MM/dd/yyyy h:mm:ss tt”, Nothing)>Today.AddDays(-30)).CopyToDataTable

If your hour format is “hh”:
dtCSV = dt_CSV.AsEnumerable.Where(function(r) DateTime.ParseExact(r(“Date”).toString, “MM/dd/yyyy hh:mm:ss tt”, Nothing)>Today.AddDays(-30)).CopyToDataTable

I hope this helps. Happy automation!

Kind regards,
Kenneth

1 Like
3

Hi @Woodson_Louis ,

Please use the below code to achieve the same.

Input.txt (1.1 KB)
Try_me.xaml (13.5 KB)

Let me know if you have any doubts about the same.

Regards,
Ashutosh Gupta

1 Like
4

Hi and thank you for your help. I apologize for the delay, other issues came up. Thanks again, BIG help!! :smiley:

5

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