TOP

GetWord function

GETWORD() Description

The GETWORD() function returns any word in the text by the given set of separators.

You can also use a ready-made tool Get word by delimiters... .

=GETWORD(Text, Entry, [Delimiters])

Text: Cell with text.
Entry: The sequence number of the occurrence of the required word. It can also have a negative value, which means searching for an entry from the end of the tape. If the value is 0 - returns all occurrences.
[Delimiters]: Optional. One or more separators. By default, all symbols that are not part of a word are used (analog \W in regular expressions ).

The GETWORD() function is easy to use. You just need to specify a cell with text and LibreOffice Calc will automatically return the required word:

=GETWORD(Text; Entry; Delimiters)

We will have the following result:

This example uses the following values:

Text: A4 - The cell from which the text is contained ("001_002.003-004:005/006@007") .
Entry: D3 - Entry serial number (1) .
Delimiters: B4 - Set of separators (if empty - default separators are used) ("") .

You can also use the feature GETSUBSTR() , which is very similar, but can split text by only one specified delimiter.

You can use the GETWORD() function by installing the extension "YLC_Utilities.oxt" .

After that, this function will be available in all files that will be opened in LibreOffice Calc.