stemmer(Y;L;P)

Returns the stem of a word for a given language.

Syntax

stemmer(Y;L;P)

Input

Argument Type Description
Y text Accepts a string literal or a column containing string values
L text A predefined value that specifies which language is being processed
Accepts one of the following values:
  • 'danish'
  • 'dutch'
  • 'english'
  • 'finnish'
  • 'french'
  • 'german'
  • 'hungarian'
  • 'italian'
  • 'norwegian'
  • 'porter'
  • 'portuguese'
  • 'romanian'
  • 'russian'
  • 'spanish'
  • 'swedish'
Note: If no language is specified, 'english' is used by default.
P NA
Note:

This parameter is reserved for future use. You must still delimit this parameter with a semicolon (;).

Return Value

Returns the stem for each of the words in Y for the language specified by the L argument.

All non-alphabetic characters in value Y are removed by stemmer(Y;L;P) processing. The function will also convert all valid values for Y to lowercase characters before operating on them.

Sample Usage

value stemmer(value;'english';)
Think thinker thinking thinks think thinker think think

Example

<base table="pub.doc.retail.product"/>
<willbe name="stem" value="stemmer(description;;)"/>
<colord cols="description,stem"/>