Forum Discussion
skim_milk
Jun 30, 2023Copper Contributor
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!
- Jul 01, 2023
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")
peiyezhu
Jul 01, 2023Bronze Contributor
=webservice("http://e.anyoupin.cn/eh3/?preg_match~message\s*(\w+\s+\w+)\s|$~" & A3 & "~1")
- skim_milkJul 01, 2023Copper ContributorI'm sorry, but no. I get a #calc error now.
- peiyezhuJul 01, 2023Bronze Contributor
- skim_milkJul 01, 2023Copper Contributor
peiyezhu Your file worked after I enabled webservices which I think might be the problem. Is there a solution not using a webservice because I don't think our security team will allow that? Please see that attached.
I really appreciate you taking the time to look into this for me.