How to search data after date

Help Activities
, ,
1

I want to search [U0003] and [U0005], after the specific date 09/14/21.

Column1,1,Line Items
11/12/15 [196727],Rose Nobrega,$0.00 CLOSED
04/08/17 [413322],Juliana Nobrega,$0.00 CLOSED
05/11/17 [428973],Juliana Nobrega,$0.00 CLOSED
09/28/17 [499129],Juliana Nobrega,$0.00 CLOSED
11/25/17 [532710],Rose Nobrega,$0.00 CLOSED
12/11/17 [542336],Juliana Nobrega,$0.00 CLOSED
09/24/18 [722232],Juliana Nobrega,$0.00 CLOSED
10/15/18 [738942],Rose Nobrega,$0.00 CLOSED
01/10/19 [807663],Rose Nobrega,$0.00 CLOSED
01/10/19 [807664],Juliana Nobrega,$0.00 CLOSED
01/12/19 [808688],Rose Nobrega,$0.00 CLOSED
02/20/19 [840523],Rose Nobrega,$0.00 CLOSED
06/19/19 [938971],Juliana Nobrega,$0.00 CLOSED
12/10/19 [1125648],Rose Nobrega,$0.00 CLOSED
02/24/21 [2083610],Juliana Nobrega,$0.00 CLOSED
03/13/21 [2146752],Rose Nobrega,$0.00 CLOSED
03/13/21 [2129980],Rose Nobrega,$0.00 CLOSED
04/19/21 [2260261],Rose Nobrega,$0.00 CLOSED
09/14/21 [2684507],Rose Nobrega,$190.00 OPEN; Blue Cross Blue Shield BCBS of NH {NH
,$215.00 09/14/21 [99213] - OFFICE EVALUATION AND
,S25.00 + Patient Payment - Credit
09/14/21 [2700954],Juliana Nobrega,$125.00 OPEN; Blue Cross Blue Shield BCBS of NH {NH Ic
,$100.00 09/14/21 [U0003] - Cov-19 amp prb hgh thru
,S25.00 09/14/21 [U0005] - Infec agen detec ampli pr
09/14/21 [2684484],Juliana Nobrega,$190.00 OPEN; Blue Cross Blue Shield BCBS of NH {NH
,$215.00 09/14/21 [99213] - OFFICE EVALUATION AND
,S25.00 + Patient Payment - Credit

2

@ashishmani - what is the expected output?

3

I want to search u0003 and u0005 after the date which I pass, in this case, I have to pass, 09/14/21
so basically I have to delete all data before the date.

4

can you help me with this?

5

09/14/21 [2684507],Rose Nobrega,$190.00 OPEN; Blue Cross Blue Shield BCBS of NH {NH
,$215.00 09/14/21 [99213] - OFFICE EVALUATION AND
,S25.00 + Patient Payment - Credit
09/14/21 [2700954],Juliana Nobrega,$125.00 OPEN; Blue Cross Blue Shield BCBS of NH {NH Ic
,$100.00 09/14/21 [U0003] - Cov-19 amp prb hgh thru
,S25.00 09/14/21 [U0005] - Infec agen detec ampli pr
09/14/21 [2684484],Juliana Nobrega,$190.00 OPEN; Blue Cross Blue Shield BCBS of NH {NH
,$215.00 09/14/21 [99213] - OFFICE EVALUATION AND
,S25.00 + Patient Payment - Credit

bold part is date, which i want to search, i want all data after the date

6

you can iterate through the datatable, get the row number when the data in the first column matches your input date, and delete the required number of rows from the datatable

7

datable is not working here, is there any way to delete all data before the date

8

can someone help me with this

9

Hi @ashishmani

Have you tried with regex?

Check on this and let me know if you face issues

Regards
Sudharsan

10

If this data is not in database, can you let us know in which format the data is present. Is it in normal text file or a csv file?

11

Hi @ashishmani !

If you want [U0003] and [U0005] you can use a regex pattern.

Here is what I see when I use this pattern: (09)\/(14)\/(21) \[U(.*?)\]

image
image1920×1080 406 KB

I wonder why having the date 09/14/21 because \[U(.*?)\] works already fine :wink:

Here is a suggestion with 3 scenarios: Regex U.xaml (20.4 KB)

Let us know if you don’t understand how it does work or if you have more questions !

12

Hi @ashishmani ,

Here is a package for Text format files. It has many activities to help you.

It has the search activity returns the line index. after a based on line index, you can read the specific line.

/R
Balamurugan.S