How to insert into a cell part of tex from another cell

valeria · November 20, 2023, 12:33pm

If I have in cell text “80/40/180” I need to insert into the other cell text, that is between “/s” (“40”). How do i do that? What formula i need to use?

"80/40/180"    >    40
"120/880/20"     >     880

Thank you.

karolus · November 20, 2023, 12:55pm

Hallo
one of:

=REGEX(A1; "^.*?/(\d+)/.*$" ; "$1" )
=REGEX(A1;"(?<=/)\d+";;1)
=REGEX(A1;"\d+(?=/)";;2)
=REGEX(A1;"^\d+?/|/\d+";"";"g")
=REGEX(A1;"\d+";;2)

koyotak · November 20, 2023, 2:56pm

@karolus please explain your =REGEX() structure so that i know how it works

sokol92 · November 20, 2023, 3:32pm

or using an Excel-compatible trick:

=TRIM(MID(SUBSTITUTE(A1; "/";REPT(" ";100));101;100))

Lupp · November 20, 2023, 6:01pm

There’s a good tutorial:

Specifics concerning the ICU “Regex flavor” used by LibreOffice you find here:

A “positive” alternative: =REGEX(A1;"(?<=/)\d+(?=/)";;1)

Villeroy · November 20, 2023, 6:15pm

98450.ods (15.2 KB)