How do i identify certain letters and numbers in the Subject field

Help Activities
,
#1

Hi all,

I am working with email automation and i need to find a way to extract the “words” “LBL0502” and “ABN 1,2” from the subject line down below.

LBL0502 DAM/BEY/IST/ARN 23-Mar-2020/24-Mar-2020 ABN 1,2

“LBL0502” is always 3 capital letters followed by 4 digits
“ABN 1,2” is always ABN followed by 1 or 1,2

Cheers
Milo

#2

@Majlopajlo - You can try this Regex with groups…

image
image738×609 86.7 KB

Regex Link : .NET Regex Tester - Regex Storm

LBL0502 = yourRegexvariable(0).groups(1).tostring
ABN 1,2 = yourRegexvariable(0).groups(2).tostring

Hope this helps

#3

@prasath17 Thank you so much. And thank you for your swift response.

All the best
Milo