Retrieve specific word from subject line in Outlook

[Majlopajlo (Milo)]

The Subject line are always. And i need to retrieve the word “STOCKHOLM” and save that word to Excel. The word “STOCKHOLM” can change but the position in subject line doesnt change.

Subject line:
Bbbbbbbbbb för AAAAA BBBBB (1111111) har anvisats till STOCKHOLM (0180)

Cheers

[ppr (Peter)]

@Majlopajlo
mybe following regex will help

looking for anything between har anvisats till AND ( ← starting bracket

[prasath17 (Guru)]

@Majlopajlo - You can try this, which captures the word without any spaces…

[Majlopajlo (Milo)]

Thank you.
Do i have to use RegEx to solve this. because i have no idea how to apply it.

[Jan_Exner (Jan)]

You can try this:

System.Text.RegularExpressions.Regex.Match(StrSubject, "(?<=till).*(?=\()").ToString.Trim

Past this code to activity Assigne.

[ppr (Peter)]

have a look here:

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

in case of you are working with API regex.Match… then ensure:

[Majlopajlo (Milo)]

@Jan_Exner Is StrSubject the name of the variable?

[Jan_Exner (Jan)]

Yeah!

[Jan_Exner (Jan)]

If you have a MailMessage type variable, you can try this: “MailMessage.Subject”

[Majlopajlo (Milo)]

@Jan_Exner Here you have my .xaml. I want to identify mails from a certain mailadress. Then i want to extract certain words from the Subject line. And transfer that word to an excel sheet.

And i dont know how to apply RegEx to this

here you have my xaml.
Kommuninformation.xaml (6.0 KB)

[ptrobot]

Just use an assign activity. The variable strCity will contain the word after “har anvisats till”. It will be empty if there’s no match.

strCity = System.Text.RegularExpressions.Regex.Match(message.Subject, "(?<=har anvisats till\s+)\w+").ToString()