Text functions

Text functions can be used to analyze, rearrange, extract, and build text strings. For example, you could use the MiddleWords function to extract specific words from supplied text.

Text functions operate on these parameters:

  • fields of type text
  • text constants (in quotation marks)
  • expressions having a text result

Function

Purpose

Char

Returns the characters for the Unicode code points in the number.

Code

Returns the Unicode code points for the characters in the text.

Exact

Returns 1 (true) if the contents of any two fields match; otherwise, returns 0 (false).

Filter

Returns from textToFilter only those characters specified in filterText, in the order they were originally entered in textToFilter.

FilterValues

Returns a text result containing only the values that were provided in filterValues, in the order they were originally entered in textToFilter.

GetAsCSS

Returns text converted to the CSS (Cascading Style Sheets) format.

GetAsDate

Returns dates in text as field type date.

GetAsNumber

Returns only the numbers in text, as field type number.

GetAsSVG

Returns text converted to the SVG (Scalable Vector Graphics) format.

GetAsText

Returns data as field type text.

GetAsTime

Returns times or timestamps in text as field type time.

GetAsTimestamp

Returns text as field type timestamp.

GetAsURLEncoded

Returns text as URL (Uniform Resource Locator) encoding, for use as a URL.

GetValue

Returns the requested value given by valueNumber from listOfValues.

Left

Returns the specified numberOfCharacters in text, counting from the left.

LeftValues

Returns values contained in text, according to the specified numberOfValues, counting from the left.

LeftWords

Returns text containing the specified numberOfWords in text, counting from the left.

Length

Returns the number of characters in a field, including all spaces, numbers, and special characters.

Lower

Returns all letters in specified text as lowercase.

Middle

Extracts the specified numberOfCharacters from text, starting at the specified character position.

MiddleValues

Returns text containing the specified numberOfValues in text, starting at startingValue.

MiddleWords

Returns text containing the specified numberOfWords from specified text, starting at startingWord.

PatternCount

Returns the number of occurrences of searchString in text.

Position

Returns the starting position of the specified occurrence of searchString in text.

Proper

Returns the first letter of each word in text as uppercase and all other letters as lowercase.

Quote

Returns the text form of text enclosed in quotation marks.

Replace

Replaces a string of characters in specified text with replacementText.

Right

Returns the specified numberOfCharacters in text, counting from the right.

RightValues

Returns values contained in text, according to the specified numberOfValues, counting from the right..

RightWords

Returns text containing the specified numberOfWords in text, counting from the right.

SerialIncrement

Returns specified text and numbers, with the numbers incremented by the specified amount.

SortValues

Sorts a list of values based on the specified data type and locale.

Substitute

Returns a text string with every occurrence of searchString in specified text replaced by replaceString.

Trim

Returns text stripped of all leading and trailing spaces.

TrimAll

Returns a copy of text with specified spaces removed or inserted.

UniqueValues

Returns unique values that are in a list based on the specified data type and locale.

Upper

Returns all letters in specified text as uppercase.

ValueCount

Returns a count of the total number of values in specified text.

WordCount

Returns a count of the total number of words in specified text.