How to search data after date

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

@ashishmani - what is the expected output?

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.

can you help me with this?

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

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

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

can someone help me with this

Hi @ashishmani

Have you tried wit regex?

Check on this and let me know if you face issues

Regards
Sudharsan

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?