Extracting text from string

Hello,

Could you please advise how to extract the word in " " into separate column using RegEx or other tools:

Book - Book Store: "Science" Close gap(s) to Shelf 'Perfect Book' (Look 'Best Composite Book Cost' proxy) per book type / per action

Need to have a separate column with Science word

Thanks

Preparation

Accepted answers

jrgo

@adombayeva

Not sure if this would work in every case, but here you go...

REGEX_REPLACE([Field1], '.*"(.+?)".*', '$1')

All comments

jrgo

@adombayeva

Not sure if this would work in every case, but here you go...

REGEX_REPLACE([Field1], '.*"(.+?)".*', '$1')

adombayeva

@jrgo

Thanks for your help, it worked well. But now I revealed that few texts have more than one " "

Thus picks up the second or third word in " " , instead of first word in " " only and another issue is that one text doesn't have " " at all, and requires to be left empty.

Book: "Science T" Use of 13-5/8" tjk vs 14" tjk

Legend Lights: WxW contingency reduction

Thanks in advance

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335