Crumb
c/excel · by Linnce@lemmy.ml · 2y

How do I extract text between two of the same characters on a string, given that said character has appeared before?

I'm trying to extract the diameter here, so for example from the strings

1234-AB-001-4"-X01 and 1234-AB-002-1.1/2"-X01

how do I exctract the 4" and 1.1/2"?

3 points · 2 comments · view on lemmy.world

2 Comments

sure@lemmy.ml · 4 pts · 2y (1 reply)

See if this does it for you: =TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",LEN(A1))),3*LEN(A1)+1,LEN(A1)))

This is assuming A1 is where the string is. The 3 in 3*LEN(A1) is what determines which string will be extracted, like so:

0  ->  1234
1  ->  AB
2  ->  001
3  ->  4"
4  ->  X01

Source: https://stackoverflow.com/questions/61837696/excel-extract-substrings-from-string-using-filterxml

Linnce@lemmy.ml · 2 pts · 2y

It worked! Thanks so much, I was going crazy over this.