FME Workbench supports the following string manipulation functions:
Commas (,) and quotes (") inside string input parameters must be escaped. Escape commas by enclosing in quotes (","). Escape quotes by preceding with a forward slash (/").
FindRegEx(string str, string regExp, [int startIdx], [bool caseSensitive], [-1])
Returns the index in string str starting at startIdx that matches regExp , or -1 if the string is not found. If startIdx is not specified, the search starts at index 0. If caseSensitive is FALSE, the search is case insensitive. Otherwise, the search is case sensitive. If -1 is specified, FindRegEx() returns the index in str starting at startIdx from the end of str going backwards.
Equivalent transformer: StringSearcher
FindString(string str, string findStr, [int startIdx], [bool caseSensitive])
Returns the index in string str starting at startIdx that matches findStr , or -1 if the string is not found. If startIdx is a negative integer, FindString() returns the index in str starting at startIdx from the end of str , then matching findStr going forward (from left to right). If startIdx is not specified, the search starts at index 0. If caseSensitive is FALSE, the search is case insensitive. Otherwise, the search is case sensitive.
Equivalent transformer: StringSearcher
FullTitleCase(string str)
Returns a string with the first letter of each word, rather than just the first letter in the string, converted to its Unicode title case variant (or to uppercase if there is no title case variant) and the rest of the string lowercase. The function ignores parentheses if they start the string or follow whitespace, and treats hyphens (-) as whitespace characters.
Equivalent transformer: StringCaseChanger
GetWord(string str, int wordNum)
Returns the wordNumth word in str . If wordNum is a negative integer, GetWord() returns the wordNumth word from the end of str. If there is no word at wordNum, an empty string is returned. Words in str must be delineated by blank spaces (space, tab, return carriage, and others).
Left(string str, int n)
Returns a substring that contains the n leftmost characters of str.
LowerCase(string str)
Returns a string with all letters in str converted to lower case.
Equivalent transformer: StringCaseChanger
PadLeft(string str, int n, [string char])
Returns the input string with at least n characters. If the input string str is not n characters long, it is padded with a prefix to this length with the specified char. If no char is specified, then a space is used.
Equivalent transformer: StringPadder
PadRight(string str, int n, [string char])
Returns the input string with at least n characters. If the input string str is not n characters long, it is padded with a suffix to this length with the specified char. If no char is specified, a space is used.
Equivalent transformer: StringPadder
ReplaceRegEx(string str, string regExp, string newStr, [bool caseSensitive])
Returns a string with all character sequences that match regExp replaced with newStr. If caseSensitive is FALSE, the search is case insensitive. Otherwise, the search is case sensitive.
Equivalent transformer: StringReplacer
ReplaceString(string str, string oldStr, string newStr, [bool caseSensitive])
Returns a string with every instance of oldStr in str replaced with newStr. If caseSensitive is FALSE, the search is case insensitive. Otherwise, the search is case sensitive.
Equivalent transformer: StringReplacer
Right(string str, int n)
Returns a substring that contains the n rightmost characters of str.
StringLength(string str)
Returns the length of the input string.
Equivalent transformer: StringLengthCalculator
Substring(string str, int startIdx[, int n])
Returns a substring of str starting at startIdx and includes n characters. If startIdx is a negative integer, Substring() returns a substring of str, starting at StartIdx from the end of str going backwards, and including n characters counting forward (from left to right). If n is not specified, then the substring starts at startIdx and goes to the end of the string. If startIdx is greater than the length of str, an empty string is returned.
TitleCase(string str)
Returns a string with the first character in str converted to its Unicode title case variant (or to uppercase if there is no title case variant) and the rest of the string lowercase.
Equivalent transformer: StringCaseChanger
Trim(string str, [string chars])
Returns a string with the leading and trailing characters in str that match the input characters in chars. If chars is not specified, whitespace is removed (tab, space, carriage return).
TrimLeft(string str, [string chars])
Returns a string with the leading characters in str that match the input characters in chars. If chars is not specified, whitespace is removed (tab, space, carriage return).
TrimRight(string str, [string chars])
Returns a string with the trailing characters in str that match the input characters in chars. If chars is not specified, whitespace is removed (tab, space, carriage return).
UpperCase(string str)
Returns a string with all letters in str converted to upper case.
Equivalent transformer: StringCaseChanger
WordCount(string str)
Returns the number of words in str. Words are delineated by blank spaces (space, tab, return carriage, and others).