troubleshooting Question

Parsing an alphanumeric string to extract individual implied elements from free text

Avatar of John Carney
John CarneyFlag for United States of America asked on
Microsoft ExcelRegular Expressions
6 Comments1 Solution194 ViewsLast Modified:
I have two functions ('GetSeats' and 'GetSeats2') that look at free text and extract certain strings from it. Please take a look at the attached workbook and let me know how to modify the two functions so that everything is parsed down to the individual seats. Something perhaps that mimics the logic of the formula in AF25?

I'd try to tell you more here but I think the workbook will speak for itself better.


Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros