Ask Your Question
0

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

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

Kenjiro43 gravatar image

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

qubit gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-23 05:13:38.041973

Comments

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

JohnSUN gravatar imageJohnSUN ( 2012-09-14 17:10:12 +0200 )edit

Where i can find references about libreoffice BASIC language?

Kenjiro43 gravatar imageKenjiro43 ( 2012-09-14 17:26:01 +0200 )edit

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

JohnSUN gravatar imageJohnSUN ( 2012-09-14 17:51:57 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

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

qubit gravatar image

(comment -> Answer for Resolution)

@JohnSUN writes:

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

edit flag offensive delete link more
0

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

RQuadling gravatar image

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

edit flag offensive delete link more

Question Tools

Stats

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

Seen: 1,356 times

Last updated: Feb 23 '13