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

Majlopajlo · February 16, 2021, 5:03pm

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

prasath17 · February 16, 2021, 5:52pm

@Majlopajlo - You can try this Regex with groups…

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

Hope this helps

Majlopajlo · February 18, 2021, 12:22pm

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

All the best
Milo