String functions
- Topics:
- Workfront Fusion
length (text or buffer)
Returns the length of text string (number of characters) or binary buffer (buffer size in bytes).
Example:
length( hello )
Returns: 5
lower (text)
Converts all alphabetical characters in a text string to lowercase.
Example:
lower( Hello )
Returns: hello
capitalize (text)
Converts the first character in a text string to uppercase.
Example:
capitalize( workfront )
Returns: Workfront
startcase (text)
Capitalizes the first letter of every word and lower cases all other letters.
Example:startcase( hello WORLD )
Returns: Hello World
ascii (text; [remove diacritics])
Removes all non-ascii characters from a text string.
Examples:
ascii(Wěošrčkřfžrýoáníté)
Returns: Workfront
ascii(ěščřž;true)
Returns: escrz
replace (text;search string; replacement string)
Replaces the search string with the new string.
Example:
replace( Hello World ; Hello ; Hi )
Returns: Hi World
Regular expressions (enclosed in /.../) can be used as search string with a combination of flags (such as g, i, m) appended:
Example:
All of these numbers X X X X are replaced with X
The replacement string can include the following special replacement patterns:
$&Inserts the matched substring.$nWhere n is a positive integer less than 100, inserts the nth parenthesized submatch string. This is 1-indexed.
Examples:
Returns: Phone number +420777111222
Returns: Phone number: +420777111222
CAUTION/ is (?<number>\d+)/ in the replacement string argument. Doing so results in an error.For more information on regular expressions, see Text parser.
trim (text)
Removes space characters at the start or end of the text.
upper (text)
Converts all alphabetical characters in a text string to uppercase.
Example:
upper( Hello )
Returns: HELLO
substring (text; start;end)
Returns a portion of a text string between the “start” position and “end” position.
Examples:
-
substring( Hello ; 0 ; 3)Returns: Hel
-
substring( Hello ; 1 ; 3 )Returns: el
indexOf (string; value; [start])
Returns the position of the first occurrence of a specified value in a string. This method returns ‘-1’ if the value that is searched for is not there. The start value indicates where in the string the search should begin.
Examples:
-
indexOf( Workfront ; o )Returns: 1
-
indexOf( Workfront ; x )Returns: -1
-
indexOf( Workfront ; o ; 3 )Returns: 6
toBinary (value)
Converts any value to binary data.
You can also specify encoding as a second argument to apply binary conversions from hex or base64 to binary data.
Examples:
-
toBinary( Workfront )Returns: 57 6f 72 6b 66 72 6f 6e 74
-
toBinary( V29ya2Zyb250 ; base64 )Returns: 57 6f 72 6b 66 72 6f 6e 74
toString (value)
Converts any value to a string.
encodeURL (text)
Encodes special characters in some text to a valid URL address.
decodeURL (text)
Decodes special characters in a URL to text.
Example:decodeURL( Automate%20your%20workflow )
Returns: Automate your workflow
escapeHTML (text)
Escapes all HTML tags in text.
Example:
escapeHTML( <b>Hello</b> )
Returns: <b>Hello</b>
escapeMarkdown(text)
Escapes all Markdown tags in text.
Example:
escapeMarkdown( # Header )
Returns: # Header
stripHTML (text)
Removes all HTML tags from text.
Example:
stripHTML( <b>Hello</b> )
Returns: Hello
contains (text; search string)
Verifies whether text contains the search string.
Examples:
-
contains( Hello World ; Hello )Returns: true
-
contains( Hello World ; Bye )Returns: false
split (text; separator)
Splits a string into an array of strings by separating the string into substrings.
Example:
split( John, George, Paul ; , )
md5 (text)
Calculates the md5 hash of a string.
Example:
md5( Workfront )
Returns: 1448bbbeaa7a9b8091d426999f1f666b
sha1 (text; [encoding]; [key])
Calculates the sha1 hash of a string. If the key argument is specified, sha1 HMAC hash is returned instead. Supported encodings: “hex” (default), “base64” or “latin1.”
Example:
sha1( workfront )
Returns: b2b30b8ae1f9e5b40fbb0696eaabdbfd8d0c087f
sha256 (text; [encoding]; [key])
Calculates the sha256 hash of a string. If the key argument is specified, sha256 HMAC hash is returned instead. Supported encodings: “hex” (default), “base64” or “latin1”.>
Example:
sha256( workfront )
Returns: ed3d7397eec7b94453035b67ba4468c883ee3bedeb57137f7371f2e0cf5e2bbc
sha512 (text; [output encoding]; [key]; [key encoding])
Calculates the sha512 hash of a string. If the key argument is specified, sha512 HMAC hash is returned instead.
Supported encodings:
- “hex” (default)
- “base64”
- “latin1”
Supported key encodings:
- “text” (default)
- “hex”
- “base64” or “binary”
When using “binary” key encoding, a key must be a buffer, not a string.
Example:
sha512(workfront)
Returns: 789ae41b9456357e4f27c6a09956a767abbb8d80b206003ffdd1e94dbc687cd119b85e1e19db58bb44b234493af35fd431639c0345aadf2cf7ec26e9f4a7fb19
base64 (text)
Transforms text to base64.
Example:
base64( workfront )
Returns: d29ya2Zyb250==