Forum Discussion
Extract word after a word
Hi all,
I'm looking to extract two words after Message not the rest of the words in the cells. Is there anyway to do that?
=TEXTAFTER(A3, "message",,1)
Thanks!
re: Is there a solution not using a webservice
Yes,you can use vba-regex as below
https://www.tutorialandexample.com/vba-regex
re:
JURY TRIAL - (Per Brendan: One complicating factor is that the Message can only conduct the trial for three days each week so based on that the Court has scheduled this for three weeks so we all need to block three weeks..)
DEADLINE -- Redaction Request for 06/08/23 Conference before Message, Sunday funday at the fair and then fireworks
JURY TRIAL - (Per Brendan: One complicating factor is that the Message can only conduct the trial for three days each week so based on that the Court has scheduled this for three weeks so we all need to block three weeks..)
The regular expression is case sensitive so that above will return none because of Message beginning with M rather than m.
New expression should be
=WEBSERVICE("http://e.anyoupin.cn/eh3/?preg_match~[mM]essage\W+(\w+\s\w+)\W~" & A4& "~1")
12 Replies
- Could you please provide some dummy.data and show your expected result ?
- I want to extract the 2 words immediately following message:
Cell: I sent a message to the end user today at 2pm
Result I'm looking for: to the
Thanks!- =webservice("http://e.anyoupin.cn/eh3/?preg_match~message\s(\w+\s\w+)\s~" & A3 & "~1")
