We help IT Professionals succeed at work.

REGEXEXTRACT in google sheets

xenium
xenium asked
on
1,101 Views
Last Modified: 2018-07-18
Hi, I want to extract "Towel bath" from the following example, where the start identifier is the first x and the finish is " L " (space L space)

7339700 5xTowel bath L 31/3-5/4 16.75 20.00 13.96

What is the correct expression?  

Here is a doc with examples, which I will update with the solution:
https://docs.google.com/spreadsheets/d/1BFjqRAhuptQTOSYhtlkYQ2P55wIvdAaaKLOSAEAsG3I

Thanks
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks a lot that worked fine.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.