Text Expression
LEN
The character count in a text is returned by the LEN function.
Syntax
LEN([column])
Example
LEN("Hello") : 5
LEN("") : 0
LEN([Home Phone]) : The length of the Home Phone column value.
EQUAL(10, LEN([Serial Number])): TRUE if the length of the character in Serial Number is exactly 10.
EQUAL(0, LEN([Some Column])) : TRUE if Some Column has no value.
GREATERTHAN(0,LEN([Some Column]) : TRUE if Some Column has a value.
Arguments
Text of any type.
Return Value
Number: This function returns character count in a text.
LEFT
The left-most characters of a text are extracted using the LEFT function.
Syntax
LEFT([column],number-of-characters)
Example
LEFT([Base], 3) : Bas
LEFT("123 Maple Dr", 5) : 123 M
LEFT("123 Maple Dr", 0) returns blank.
Arguments
Note: Non-Number values may be accepted but unexpected results may occur.
Return Value
Text: The starting number of characters from the text.
Note: If the number of characters is greater than the length of text or less than 0, the text is returned completely.
Learn more about LEFT
RIGHT
The RIGHT function returns the rightmost characters of a text.
Syntax
RIGHT([column],number-of-characters)
Example
RIGHT([Base], 2) : se
RIGHT("123 Maple Dr", 5) : le Dr
RIGHT("123 Maple Dr", 0) returns blank.
Arguments
Note: Non-Number values may be accepted but unexpected results may occur.
Return Value
Text: The last number of characters from the text.
Note: If the number of characters is greater than the length of text or less than 0, the text is returned completely.
Trim
TRIM removes spaces from the beginning and end of the string, and removes duplicate spaces from the interior of the string.
Syntax
TRIM(text)
TRIM([column_1])
Argument
Text from which we wish to remove spaces.
Example
TRIM([Function]): It will remove spaces from the Function column.
CONCATENATE
A new text is returned by the CONCATENATE function after merging together each text in the order given.
Syntax
CONCATENATE([column_1],[COLUMN_2])
Example
CONCATENATE([Ba],[Number]) : Ba Number
CONCATENATE("Good", " ", "evening", "!") : Good evening!
CONCATENATE("Good evening, ", [First Name], "!") : Good evening, Martin!
CONCATENATE([Last Name], ", ", [First Name]) : Sandwich, Martin
CONCATENATE("Today is ", MONTH("4/1/2010"), "/", DAY("4/1/2010"), ".") : Today is 4/1.
Arguments
Part (any type): A value to be included in the merged text.
Return Value
Text: A new value after merging together of each part in the order given.
Learn more about CONCATENATE
FIND
The position of the character in a text is determined by the FIND function.
Syntax
FIND([Fragment], [find])
Example
FIND("a", "abc") : 1
FIND("b", "abc") : 2
FIND("f", "abc") : 0
FIND("Red", "I'm bored!") returns 0 as Red--with an uppercase R--doesn't occur in I'm bored!.
FIND(UPPER("Red"), UPPER("I'm bored!")) returns 7 as the all-uppercase RED occurs at that position in the all-uppercase I'M BORED!
FIND("@", [Email]) returns the position of the first at sign (@) in Email, or 0 if not present.
Return Value
Number: The position in the search value at which the fragment was found, or zero (0) if not found.
Note: Search is case-sensitive, that is both upper- and lower-case letters are not equivalent.
Learn more about FIND
UPPER
The text is converted to uppercase using the UPPER function.
Syntax
UPPER(text-to-convert-to-upper-case)
Example
UPPER([Text]) : TEXT
Arguments
Text of any type
Return Value
Text: conversion of all lowercase letters to uppercase in a text.
Learn more about UPPER
LOWER
The text is converted to lowercase using the LOWER function.
Syntax
LOWER(text-to-convert-to-lower-case)
Example
LOWER([Text]) : text
Arguments
Text of any type
Return Value
Text: conversion of all uppercase letters to lowercase in a text.