Ens cal la vostra ajuda!

TEXTBEFORE

Returns the text that occurs before the start of given instance of a delimiter substring.

Sintaxi

TEXTBEFORE( Text [; Delimiter [; Instance Number [; Match Mode [; Match End [; If Not Found ]]]]])

Text: the original text.

Delimiter: (optional) the delimiter. Multiple delimiters can be supplied. If omitted or supplied as an empty string, then returns the error #N/A or the value expressed by If Not Found.

Instance Number: (optional) the instance of the delimiter before which to extract text. The default is 1. A negative number starts searching from the end. Value 0 returns the error #N/A

Match Mode: (optional) set to 1 to perform a case-insensitive match. The default is 0.

Match End: (optional) set to 1 to treat the end of text as as accitional delimiter. The default is 0.

If Not Found: (optional) the value returned if no match is found. The default is #N/A.

Icona de nota

Es pot ometre qualsevol dels arguments opcionals. Un argument opcional requereix que tots els separadors anteriors estiguin presents.


Exemples

=TEXTBEFORE("To be or not to be";" be";2;0;0;"@@@") returns the string "To be or not to", taking up to the second instance of the delimiter " be".

=TEXTBEFORE("To be or not to be";"question";1;0;0;"@@@") returns the text "@@@" because the delimiter "question" is not in the source text.

Interactions between Delimiter, Instance number and MatchEnd:

Text

Delimiter

Instance

MatchMode

MatchEnd

IfNotFound

TEXTBEFORE

T

D

N

Mode

MatchEnd

NotFound

TEXTAFTER

to_be_or_not_to_be

to

-4

0

0

@@@

@@@

to_be_or_not_to_be

to

-3

0

0

@@@

@@@

to_be_or_not_to_be

to

-2

0

0

@@@

to_be_or_not_to_be

to

-1

0

0

@@@

to_be_or_not_

to_be_or_not_to_be

to

0

0

0

@@@

#N/A

to_be_or_not_to_be

to

1

0

0

@@@

to_be_or_not_to_be

to

2

0

0

@@@

to_be_or_not_

to_be_or_not_to_be

to

3

0

0

@@@

@@@

to_be_or_not_to_be

to

4

0

0

@@@

@@@

to_be_or_not_to_be

to

-4

0

0

@@@

@@@

to_be_or_not_to_be

to

-3

0

1

@@@

to_be_or_not_to_be

to

-2

0

1

@@@

to_be_or_not_to_be

to

-1

0

1

@@@

to_be_or_not_

to_be_or_not_to_be

to

0

0

1

@@@

#N/A

to_be_or_not_to_be

to

1

0

1

@@@

to_be_or_not_to_be

to

2

0

1

@@@

to_be_or_not_

to_be_or_not_to_be

to

3

0

1

@@@

to_be_or_not_to_be

to_be_or_not_to_be

to

4

0

1

@@@

@@@


Informació tècnica

Icona de consell

El LibreOfficeDev inclou aquesta funció des de la versió 25.8.


This function is NOT part of the Open Document Format for Office Applications (OpenDocument) Version 1.4. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.TEXTBEFORE