CODEWITHSUNDEEP
regexexcelextract
Stephen Watts
Stephen Watts

Reputation: 11

Regex text extraction

I'm trying to use SEO Tools for Excel to extract from the following line:

"productLineCategories":"product abc"

Want to extract just: product abc (no quotes or semicolons)

Using productLineCategories(.*) emits the full "productLineCategories":"product abc"

How can I extract just the value?

Upvotes: 1

Views: 54

Answers (1)

SamWhan
SamWhan

Reputation: 8332

Basic regex:

"productLineCategories":"([^"]*)"

Not familiar with SEO tools, but according to doc =RegexpIsFind returns an array of capture groups. With this regex you'll find the second string in the first capture group.

Regards

Upvotes: 1

Related Questions