Im looking for a way to remove the last character (") returned by my REGEXEXTRACT formula which is:

=SI(ESTNA(REGEXEXTRACT(B2,"\nmarket_hash_name: ""(.*)")),"",REGEXEXTRACT(B2,"\nmarket_hash_name: ""(.*)"))

The result right now is > Sticker | Battle Scarred" And i'd like to remove the " at the end.

Thank you so much for your help!

CodePudding user response：

It's hard to suggest solid formulas without access to the actual spreadsheet and data, because we have no context. The task becomes even more difficult when there are language differences in the formula elements (this particular Stack site has mostly English-language volunteer contributors and visitors).

However (and this is an educated yet untested guess), you can try this:

=SI.ERROR( REGEXEXTRACT(B2, "market_hash_name:\s*" & CARACTER(34) & "([^" & CARACTER(34) & "]*)") )