Hi
I’ve been trying to select just a bit of a string to the nextcolumn, but failing (tried Text to Columns seperated by comma, but it goes all over the place)
The strings look like this: Al_Solh,Mounira.14463_art.Double_Burger_and_Two_Metamorphoses_,_A.19951.master.mov, 5.210 GB, 25 min, Video digital
Can anyone tell me how to get just the ‘‘25 min’’ to a different column and leave the rest behind?
Thank you so much!
hallo
the last portion of Text between commas:
=TRIM(REGEX( A1 ; "^.*,([^,]+),[^,]+$" ; "$1" ))
or
=TRIM(REGEX( A1 ; "^.*,(.+?),[^,]+$" ; "$1" ))
the Textportion wich looks like a duration in minutes:
=REGEX($A1 ; "^.*?(\d+ *min).*$" ; "$1" )Thanks,
but where and how do i apply this? (also i’m using a dutch language version of the application, is that an issue with this?)
If i fill this in as a formula in a different cell a get a #NAME? error
(sorry my libreoffice calc knowledge sucks)
Thanks again!
I cannot tell the dutch located Functionnames but the german Names are TRIM ⇒ GLÄTTEN and REGEX ⇒ REGAUS
Tip: Menu / Tools / Options (Alt+F12). LibreOffice Calc / Formula, check Use English function names.
Perfect, thank you so much!!
I taught about that…but then realizing thats the UI may also »dutch« 
Actually another question, sorry
So now all those ‘‘25 min’’ type numbers are in a seperate column (i’ve taken the ‘‘min’’ off, so its just the number)
but now when i try to do a sum of those, it just gives me always ‘‘0’’ as an answers.
Is this because i’m trying to do a sum of just a row of formulas?
How can I make a sum up of all the numbers that the formula above has created?
thanks
thats because »REGEX« returns Text, no numeric values, you should cast to Values:
=REGEX($A1;"^.*?(\d+) *min.*$";"$1") * 1 # implizit
=VALUE(REGEX($A1;"^.*?(\d+) *min.*$";"$1") # explizitThank you so much, big help!