CODEWITHSUNDEEP
regexgoogle-sheetsgoogle-sheets-formulaarray-formulas
Lewimaron
Lewimaron

Reputation: 5

Extracting part of a string in Google Sheets

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?

Upvotes: 0

Views: 320

Answers (2)

player0
player0

Reputation: 1

try:

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

0

for array do:

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

0

Upvotes: 0

JPV
JPV

Reputation: 27292

Assuming the string in A1, try

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

and see if that works?

Upvotes: 1

Related Questions