Extract Last word

Help Activities
, ,
1

Hi Team,

Want to extract only the word Offer from the below line ignoring question mark

Got a Job Offer ?

2

Hi @Honda

Use the below regular expression, it will extract the last word before the question mark.

\w+(?=\s+\?)

A regex editor interface showing a regular expression pattern and its match highlighting the word "Offer" in the text "Got a Job Offer?" (Captioned by AI)
A regex editor interface showing a regular expression pattern and its match highlighting the word "Offer" in the text "Got a Job Offer?" (Captioned by AI)508×303 8.87 KB

- Assign -> Input = "Got a Job Offer ?"
- Assign -> Output = System.Text.RegularExpressions.Regex.Match(Input.toString, "\w+(?=\s+\?)").Value.toString

The image depicts a sequence of commands in an automation workflow where a string "Got a Job Offer ?" is processed with a regular expression, resulting in "Offer", which is then displayed in a message box. (Captioned by AI)
The image depicts a sequence of commands in an automation workflow where a string "Got a Job Offer ?" is processed with a regular expression, resulting in "Offer", which is then displayed in a message box. (Captioned by AI)759×443 17.6 KB

Hope it helps!!

3

Hi @Honda

Get the word after a specific word i.e Job you can use

extractedValue = System.Text.RegularExpressions.Regex.Match(yourString, "(?<=Job\s)\w+\bOffer\b").Value

Get the word behind “?” use this

extractedValue =System.Text.RegularExpressions.Regex.Match(yourString, "\w+(?=\s?\?)").Value

Hope this helps

4

@Honda
yourString = “Got a Job Offer ?”
lastWord = System.Text.RegularExpressions.Regex.Match(yourString.TrimEnd("?"c), “\w+$”).Value

hope it is helpful!!

5

Hi @Honda

Can you try the below

A screenshot of a workflow segment in an automation tool assigns values to variables and displays a message box with the last word of a given input string "Got a Job Offer?" after trimming the question mark. (Captioned by AI)
A screenshot of a workflow segment in an automation tool assigns values to variables and displays a message box with the last word of a given input string "Got a Job Offer?" after trimming the question mark. (Captioned by AI)1030×525 24.6 KB

LastWord = Input.TrimEnd("?"c).Trim.Split(" "c).Last

Regards,

6

Hello @Honda,
you can try this expression in an assign activity(str variable) -

System.Text.RegularExpressions.Regex.Matches(Str_, "[a-zA-Z]+").Cast(Of System.Text.RegularExpressions.Match)().Select(Function(m) m.Value).ToArray().Last.Tostring

If you find it usefull please mark this as soluttion.