Extracting multiple data using regex based on strings

Help Activities
, , , , , , ,
1

How would be get the ff using regex ? get string that starts with AT and ends with the number for example AT-210209-141 , AT-210209-421, AT-210209-423 . Also get the string starts with CMTRX like CMTRX00015591 , also starting with PMTRX like PMTRX0003232 and string starting with AONCUR like AONCUR-AP-34334. How do we dynamically do that ? any idea ? thanks.
#DATA

El AT-210209-141 ! General
o AT-210209-421 General 
El AT-210209-421 General 
o AT-210209-423 General 
El AT-210209-423 General
AL CT-210209-423 General
El CMTRX0012323 General 
o CMTRX00053233 General 
El CMTRX00015591 General 
El CMTRX00015591 General 
El PMTRX0001223 General 
El PMTRX0003232 General 
El AONCUR-AP-34334 General 
El AONCUR-AP-4343 General 
El AONCUR-AP-23342 General 
El AMPay00012345 General 
AL L4-210209-423 General
AL TR-210209-423 General
2

As you can see there are multiple filters and basis like PMTRX , CMTRX , AT . How do we dynamically manage that using regex ? Thanks.

3

@AhmedKutraphali - Could you please try like this…You can use regex groups to extract the string you want.

image
image677Ă—845 40.5 KB

4

@AhmedKutraphali
As an alternate a pattern defining some more restrictions on digit, letter, -

grafik
grafik357Ă—519 7.3 KB

2 Likes
5

What if I only wanted to get strings that begin with the ff. if and get the value like CMTRX00015591 , PMPay00012345 and so on. If the string does not begin with the example below the regex should ignore it. @prasath17 @ppr .

a. CMTRX
b. PMTRX
c. BT
d. LT
e. PMPay
f. CONCUR-AP-###
G. AT

6

@AhmedKutraphali …sorry I couldn’t get you…which one you want to omit and which ones you want to keep?

1 Like
7

I want to keep all data that starts with but only up to the last number it should not include text like General or anything for example CMTRX00015591 ! General . The output should be CMTRX00015591. @prasath17

keep data that start with the following below.

  1. CMTRX
  2. PMTRX
  3. BT
  4. LT
  5. PMPay
  6. CONCUR-AP-###
  7. AT
8

Another set of data example

El BT-210209-141 !General
o BT-210209-421 General 
El BT-210209-421 General 
o BT-210209-423 General 
El BT-210209-423 General
AL CT-210209-423 General
El CMTRX0012323 General 
o CMTRX00053233 General 
El CMTRX00015591 General 
El CMTRX00015591 General 
El PMTRX0001223 General 
El PMTRX0003232 General 
El CONCUR-AP-34334 General 
El CONCUR-AP-4343 General 
El CONCUR-AP-23342 General 
El PMPay00012345 General 
AL L4-210209-423 General
AL TR-210209-423 General
9

How would you Like to handle the Case of L4?
L4-210209-423

1 Like
10

@AhmedKutraphali …we have already provided the regex …please check my screenshot above …your text is under $1 column

1 Like
11

L4 should not be included since it is not on the list of string that begins with

  1. CMTRX
  2. PMTRX
  3. BT
  4. LT
  5. PMPay
  6. CONCUR-AP-###
  7. AT
12

@AhmedKutraphali - What about the CT?

1 Like
13

CT also not included it should only get text that begins with the following

  1. CMTRX
  2. PMTRX
  3. BT
  4. LT
  5. PMPay
  6. CONCUR-AP-###
  7. AT
14

@AhmedKutraphali - please check below under $1 column

image
image1403Ă—730 137 KB

Please find the starter help here: Regex_Ahmed.zip (35.4 KB)

1 Like
15

@prasath17 One last question sir how do we add a filter or checking that will determine if its a previous date ? in this format YYMMDD

for example if item equal toBT-210210-141 , it should check the date after BT which is 210210(YYMMDD) then the bot will log a message that it is a previous day based on our current date today . Today is 11 and last day is 10 which is 210210 in YYMMDD format. Thanks

16

@AhmedKutraphali - Please check this…Regex_Ahmed.zip (35.9 KB)

1 Like
17

Thank you so much @prasath17 . May God bless you.

18

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