Function EN Version 4.50

@Contains

List Misc Text

Syntax

@Contains(TEXT1;TEXT2);

@Contains(TEXTLIST1;TEXT2);

@Contains(TEXT1;TEXTLIST2);

@Contains(TEXTLIST1;TEXTLIST2);

@Contains(TEXT1;TEXT2;RETPOS3);

@Contains(TEXTLIST1;TEXT2;RETPOS3);

@Contains(TEXT1;TEXTLIST2;RETPOS3);

@Contains(TEXTLIST1;TEXTLIST2;RETPOS3);

Description

Determines whether in TEXT/TEXTLIST TEXT1/TEXTLIST1 the TEXT TEXT2 or an element of TEXTLIST TEXTLIST2 is contained wholly or partially and returns TRUE if this is the case. An empty TEXTLIST1, which cannot contain anything, not even an empty TEXTLIST2. In this case, the result is therefore always FALSE.
If @Contains is called with 3 parameters (RETPOS3), it returns the position of the element in the list for which the comparison first returned positive.

Example: @Contains(TEXT1;TEXT2)

TEXT1:="Hallo Welt";
TEXT2:="Welt";
@Contains(TEXT1;TEXT2); returns 1

TEXT1:="Hallo Welt";
TEXT2:="Erde";
@Contains(TEXT1;TEXT2); returns 0

Example: @Contains(TEXTLIST1;TEXT2)

TEXTLIST1:="Suche":"Brauche":"Möchte";
TEXT2:="cht";
@Contains(TEXTLIST1;TEXT2); returns 1

TEXTLIST1:="Suche":"Brauche":"Möchte";
TEXT2:="Verkaufe";
@Contains(TEXTLIST1;TEXT2); returns 0

Here, TEXT2 in an element of TEXTLIST1 is searched for.

Example: @Contains(TEXT1;TEXTLIST2)

TEXT1:="Su";
TEXTLIST2:="Suche":"Brauche":"Möchte";
@Contains(TEXT1;TEXTLIST2); returns 0

TEXT1:="Möchte";
TEXTLIST2:="Suche":"Brauche":"Möchte";
@Contains(TEXT1;TEXTLIST2); returns 1

Here, an element of TEXTLIST2 in TEXT1 is searched for.

Example: @Contains(TEXTLIST1;TEXTLIST2)

TEXTLIST1:="Müller":"Huber":"Maier";
TEXTLIST2:="Klein":"Schulze":"Müller";
@Contains(TEXTLIST1;TEXTLIST2); returns 1

TEXTLIST1:="Müller":"Huber":"Maier";
TEXTLIST2:="Klein":"Schulze":"Meyer";
@Contains(TEXTLIST1;TEXTLIST2); returns 0

TEXTLIST1:="";
TEXTLIST2:="";
@Contains(TEXTLIST1;TEXTLIST2); returns 0;

Here, an element of TEXTLIST2 in TEXTLIST1 is searched for.

Example: @Contains(TEXTLIST1;TEXT2;RETPOS3)

TEXTLIST1:="Suche":"Brauche":"Möchte";
TEXT2:="cht";
@Contains(TEXTLIST1;TEXT2;RETPOS3); returns 1
In RETPOS3 returns 3.

TEXTLIST1:="Suche":"Brauche":"Möchte";
TEXT2:="Verkaufe";
@Contains(TEXTLIST1;TEXT2;RETPOS3); returns 0
The contents of RETPOS3 is undefined.

Here, TEXT2 in an element of TEXTLIST1 is searched for.

Note : This text was machine-translated and may contain inaccuracies.