Extracting part of a string in Google Sheets

Question

I'm trying to extract the classname from a list of UE4 blueprint paths that look like this:

"Blueprint'/Game/Aberration/CoreBlueprints/Weapons/PrimalItemAmmo_Zipline.PrimalItemAmmo_Zipline'"

The end result needs to be something like this:

PrimalItemAmmo_Zipline_C

I guess the easiest way would be to extract everything between the "." and the apostrophe at the end, before appending the _C. I've tried a few different solutions I've found online, mostly modified from formulas for getting filenames from filepaths, but I can't get any of them to work properly. What would be the best way to do this?

JPV · Accepted Answer · 2019-12-30 20:10:44Z

1

Assuming the string in A1, try

=substitute(regexextract(A1, "[^.]*$"), char(39)&char(34), "_C")

and see if that works?

edited Dec 30, 2019 at 20:10

answered Dec 30, 2019 at 20:06

JPV

27.4k4 gold badges37 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lewimaron Over a year ago

That pulled the word Blueprint from the start of the path.

Lewimaron Over a year ago

Wait, apparently I've just been having a major brain collapse and have been testing all my formulas on G1 when the path is in G2... I'm an idiot and this solution works.

player0 · Accepted Answer · 2019-12-30 20:12:21Z

0

try:

=REGEXEXTRACT(A1, "\.(.*)'")&"_C"

for array do:

=ARRAYFORMULA(IFNA(REGEXEXTRACT(A1:A, "\.(.*)'")&"_C"))

answered Dec 30, 2019 at 20:12

player0

131k14 gold badges92 silver badges149 bronze badges

Collectives™ on Stack Overflow

Extracting part of a string in Google Sheets

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related