Ask Your Question
2

How to extract element from string [closed]

asked 2013-08-17 08:32:34 +0200

the_nookie gravatar image

updated 2013-10-11 20:56:05 +0200

manj_k gravatar image

I want to extract the elements in a specific position in a stsring and to put them in cells in a diferent sheet. They are separated by interval.

this is the excel function which makes it =ExtractElement(A1,1,".")

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-07 02:16:44.852313

Comments

This shows that text function names could be more intuitive. I would expect "SUBSTR" or "SUBSTRING", rather than "MID". I haven't seen "MID" in any programming language.

dandv gravatar imagedandv ( 2017-11-21 17:24:24 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2013-08-17 11:47:32 +0200

m.a.riosv gravatar image

In LibreOffice help:

MID("Text"; Start; Number)
Text is the text containing the characters to extract.
Start is the position of the first character in the text to extract.
Number specifies the number of characters in the part of the text.
Example =MID("office";2;2) returns ff.

To find the start number for a specific character.
FIND("FindText"; "Text"; Position)
FindText refers to the text to be found.
Text is the text where the search takes place.
Position (optional) is the position in the text from which the search starts.
Example =FIND(76;998877665544) returns 6.

Or

SEARCH("FindText"; "Text"; Position)
FindText is the text to be searched for.
Text is the text where the search will take place.
Position (optional) is the position in the text where the search is to start.
Example =SEARCH(54;998877665544) returns 10.

The difference between FIND and SEARCH are:
FIND is case sensitive.
SEARCH allow regular expression.

edit flag offensive delete link more

Comments

This type processes can be done with regex (Regular Expression) method. For example ,I made a template about "Seperating Texts and Numbers In Cell" with Regular Expression.Data are parsed with a button.

Example Can Be Viewed and Can Be Downloaded Here

kadrleyn gravatar imagekadrleyn ( 2016-01-03 19:44:25 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-08-17 08:32:34 +0200

Seen: 35,358 times

Last updated: Aug 17 '13