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

[Kenjiro43]

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

[JohnSUN]

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

[Kenjiro43]

Where i can find references about libreoffice BASIC language?

[JohnSUN]

Help or very good book of Andrew Pitonyak - English Macro Document

[RQuadling]

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 ’ / '.

[qubit1]

(comment → Answer for Resolution)

@JohnSUN writes:

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