Functions Reference

Chapter 12
|
Text functions 181
Description
Returns a text string with every occurrence of searchString in text replaced by
replaceString in text.
The Substitute function is case-sensitive. Compare to the Replace function.
Multiple substitutions are allowed when you enclose each pair of searchString and
replaceString parameters within square brackets [ ] and separate them with
semicolons. Each search and replace list item is also separated by semicolons. For
example:
Substitute(text; [search1; replace1]; [search2; replace2]; ...
[searchN; replaceN])
Examples
Substitute(Description;“WYSIWYG.”;“What you see is what you get”)
replaces every occurrence of the acronym “WYSIWYG.” in the Description field with the
phrase What you see is what you get.
Substitute(text;[“a”;“A”];[“b”;“B”]) replaces every lowercase a or b with A
or B.
Trim
Format
Trim(text)
Parameter
text - any text expression or text field
Data type returned
text
Description
Returns text stripped of all leading and trailing spaces.
Tip Use the Trim function to remove unneeded spaces when you convert files from other
programs or systems that require a fixed number of characters per field, or to remove
spaces accidentally typed during data entry.
Examples
Trim(“ Tom ”) returns Tom.
Trim(Middle(“00230013 William 1234”;9;9)) returns William.