Text Functions

Text Functions

Function	Description
Concatenate	Concatenates two or more strings.
CR	Generates a Carriage Return.
CRLF	Generates a Carriage Return/Line Feed.
EvaluateExpression	Evaluates the specified expression. The caller activity must read the all lookups used in the expression separately.
FormatMultivaluedList	Formats the multivalued list as per the specified format string.
GenerateRandomPassword	Generates an alphanumeric password of the specified length.
Left	Returns the leading substring of specified length. If the specified length is greater than the input string, the entire input string is returned.
LeftPad	Returns a new string that is equivalent to string specified in the first input parameter, but right-aligned and padded on the left with as many padding characters as needed to create the specified length.
Length	Returns the length of the string.
LowerCase	Converts all characters in a string to the lower case based on current culture.
LTrim	Removes leading white spaces or specified characters from a string.
Mid	Returns a specified number of characters from a specified position in a string.
NormalizeString	Normalizes the first string, first by replacing the character substitutions specified in the second string and then removing all diacritics using the .NET string normalization function.
Null	Returns a null value. Typically used in Update Resources activity with the "Allow Null" checkbox to clear the value of an attribute.
ProperCase	Converts the first character of each space-delimited word in a string to upper case and all other characters are converted to lower case.
RegexMatch	Returns a Boolean value indicating if the string matches the regex pattern.
RegexReplace	Replaces the Regex pattern with the specified string.
ReplaceString	Replaces all occurrences of a string to another string.
Right	Returns a trailing substring of specified length. If the specified length is greater than the input string, the entire input string is returned.
RightPad	Returns a new string that is equivalent to string specified in the first input parameter, but left-aligned and padded on the right with as many padding characters as needed to create the specified length.
RTrim	Removes trailing white spaces or specified characters from a string.
SplitString	Splits the string into substring delimited by the specified separator.
TitleCase	Converts the specified string to title case (except for words that are entirely in uppercase, which are considered to be acronyms).
Trim	Removes leading and trailing white spaces or specified characters from a string.
UpperCase	Converts all characters in a string to the upper case based on current culture.
Word	Returns a word contained within a string, based on parameters describing the delimiter character to use and the word number to return.
WrapXPathFilter	Wraps the supplied XPath filter in the necessary XML to prepare for use in a criteria-based group or set definition.