Need Help in Regex From Email Subject

[Binod_Kumar_Biswal]

Hello,
I want to extract the company name from email subject.

54267 ABC COMPANY EXPENSE_24_05_2024 12:25:36

Please note the Amount before ABC COMPANY will always be floating since expense amount will vary company to company but Expense will be Expense word will be constant followed by timestamp.

Thanks in Advance

[vrdabberu (Varunraj Dabberu)]

@Binod_Kumar_Biswal

EXPENSE

HI @Binod_Kumar_Biswal

[A-Za-z]+.*(?=\s+EXPENSE)

Regards

[Binod_Kumar_Biswal]

Hi @vrdabberu ,

Thanks for the reply but I am getting the below error.

[vrdabberu (Varunraj Dabberu)]

Hi @Binod_Kumar_Biswal

Please use the below syntax:

System.Text.RegularExpressions.Regex.Match(SubjectLine,"[A-Za-z]+.*(?=\s+EXPENSE)").Value.ToString.Trim()

Regards