Need Build-in Function about "FIND()" and "SEARCH()"

Question

asked 2012-09-14 12:24:26 +0200

Kenjiro43
1 ● 2

updated 2013-02-23 01:14:02 +0200

qubit

5816 ● 3 ● 50 ● 43

I want to create my function in LibreOffice Calc. How do i find text? I couldn't use "FIND()" and "SEARCH()" just like i use in Calc. Did libreoffice have build-in function to find text?

Thank You
Kenjiro43

UPDATE: When I call FIND i got error. They said function FIND didn't exist

For example:

Dim temp as Integer
temp=FIND("-","This-is string")

I got error

Accepted Answer

answered 2013-02-23 01:14:59 +0200

qubit

5816 ● 3 ● 50 ● 43

(comment -> Answer for Resolution)

@JohnSUN writes:

Of course this is a mistake. In BASIC is written as: temp=InStr("This-is string","-")

Answer 2

answered 2012-09-14 12:28:12 +0200

RQuadling
3 ● 2

I use FIND() ...

=LEFT(A1, FIND(" / ", A1))

I've just used this function to create a clipped version of a description, truncating the text to the first ' / '.

Need Build-in Function about "FIND()" and "SEARCH()"

Comments

2 Answers

Resources

Donate

Question tools

Stats

Related questions