Search

Module: Editor

Version: 2.2.1 +

Type: Long or Double

Category: Text

 

Description

The function 'Find' returns the position number of a text string within a text.

Parameters

Text:

In this parameter you can refer to or fill in the text.

Lookup_text:

In this parameter you can refer to or fill in the lookup text.

Example

Description

In this example the formula 'Find' is used for the text 'Example Futurama'. The formula has as lookup_text the text Futurama. The formula will returns the position number of the lookup text.

Values Parameters

Text:

Example Futurama.

Lookup_text:

Futurama.

Result

Result:

8

In front of  the word 'Futurama' you will find 8 characters, the word 'Example' has 7 characters and the space counts as 1 character.

Updated: 2013-03-25