Manual

188 KEN-TM / KET_TM-BA-e-1420
There are additional functions that modify text values. These functions allow you to
amend text during its issue:
• remove (“text“, starting point (number), number of characters for deleting
(number)) – The rest of the text will be issued after this entry. The
sentence or text from the defined starting point to the specified number of
characters will be deleted.
Example: {5:remove("sample text“,8,4)} = example
• substring ("text value“, starting point (number), number of characters for
copying (number)) – This function is used to extract only certain words
from the overall text.
Example: {5:substring("sample text“,1,8)} = example
• tolower ("text value“) – Converts text in question to lower-case characters.
Example: {5:tolower("EXAMPLE“)} = example
• toupper ("text value“) – Converts text in question to upper-case
characters.
Example: {5:toupper("example“)} = EXAMPLE
• replace ("text value“, old text, new text) – Resets text with changed letters
or parts of the text from second or third parameter.
Example: {5:replace("2.000“, "0“, "1“)} = 2.111
Note:
Text values need to be presented in inverted commas " ".
IMPORTANT: Always write text details in inverted commas.
When using existing variables from the database please use square brackets [ ] .
Please see also example using variable 50 (product name) below:
Toupper([50]) = APPLE