You are here: Function Reference > String Functions

String Functions

String functions manipulate data to conform to a certain format. The string functions are summarized in the table below.

Note

If the destination of the data is a field with a specific format, keep in mind the system will execute any DAL processing before it applies the format specified in the field’s format mask.

Function	Result
BankRound	Rounds numbers based on Banker’s rounding. Values below 0.5 go down, values above 0.5 go up, and values of exactly 0.5 go to the nearest even number.
CFind	Finds and returns the position of a character (or string of characters) within another string of characters.
Char	Converts an integer into a single character.
CharV	Converts a single character into an integer value.
CodeInList	Searches for a string in a list of a strings.
CPSTR	Convert a string constant, or any value from a string variable, to a specific codepage number.
Cut	Removes characters from a string at a specified position and returns the result.
DeFormat	Removes formatting from a string field and returns the result.
Find	Finds the position of a substring within a string and returns the result.
Format	Formats a string field and returns the result.
FrenchNumText	Converts a number into a string of words and returns the result (in French).
GermanNumText	Converts a number into a string of words and returns the result (in German).
Insert	Inserts a substring into a string at a specified position and returns the result.
InsertListItem	Inserts/appends a new item into a formatted list of items and the modified list of items is returned.
JCenter	Returns a string center justified.
JLeft	Returns a string left justified.
JRight	Returns a string right justified.
Left	Returns a specified number of left most characters.
LEN	Returns the current length of the string.
ListInList	Searches character string lists and returns the ordinal position (integer) of the first string in the second parameter that matches any of the strings in the first parameter.
Lower	Converts all characters to lowercase and returns the result.
NL	Retrieves a string that contains a new line character sequence.
NumText	Converts a number into a string of words and returns the result (in English).
PAD	Adds trailing spaces or characters and returns the result.
ParseListCount	Counts the indexed components within the formatted text
ParseListItem	Returns the indexed components from the formatted text.
RemoveListItem	Removes a specific indexed component from the formatted list of items and the modified list of items is returned.
Right	Returns a specified number of right most characters.
Round	Returns a number rounded to the nearest specified decimal point.
SpanishNumText	Converts a number into a string of words and returns the result (in Spanish).
STRCompare	Compares two strings, considering case.
SUB	Returns a substring from a string at a specified position.
Trim	Removes end spaces and returns the result.
Upper	Converts all characters to uppercase and returns the result.

Open table of contents