Forum Discussion
Extract word after a word
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")
(if known at least ten (10) days before the proceeding unless message assigned to the case for all purposes).
- =webservice("http://e.anyoupin.cn/eh3/?preg_match~message\s*(\w+\s+\w+)\s|$~" & A3 & "~1")
- I'm sorry, but no. I get a #calc error now.