Answered step by step
Verified Expert Solution
Question
1 Approved Answer
REGEXMATCH a string from the beginning of the sentence until a string: Example: email send 9.15, 9.17 mentee dropped 9.17 I want to get and
REGEXMATCH a string from the beginning of the sentence until a string:
Example: "email send 9.15, 9.17 mentee dropped 9.17"
I want to get and check if the "9.15" and "9.17" contains in the sentence before the string "dropped" using regexmatch on google sheet. Basically, I want to check if "email send 9.15, 9.17 mentee" contain "9.15" or "9.17"
I am trying to use .^(?:9.15)(?=dropped) but is not working.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started