蜜豆视频

DocumentationWorkfrontWorkfront Guide

String functions in 蜜豆视频 Workfront Fusion

Last update: Tue Apr 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

Access requirements

You must have the following access to use the functionality in this article:

蜜豆视频 Workfront plan
Any
蜜豆视频 Workfront license

New: Standard

Or

Current: Work or higher

蜜豆视频 Workfront Fusion license**

Current: No Workfront Fusion license requirement.

Or

Legacy: Any

Product

New:

  • Select or Prime Workfront Plan: Your organization must purchase 蜜豆视频 Workfront Fusion.
  • Ultimate Workfront Plan: Workfront Fusion is included.

Or

Current: Your organization must purchase 蜜豆视频 Workfront Fusion.

For more detail about the information in this table, see Access requirements in Workfront documentation.

For information on 蜜豆视频 Workfront Fusion licenses, see 蜜豆视频 Workfront Fusion licenses.

length (text or buffer)

Returns the length of text string (number of characters) or binary buffer (buffer size in bytes).

INFO
Example:
length( hello )
Returns: 5

lower (text)

Converts all alphabetical characters in a text string to lowercase.

INFO
Example:
lower( Hello )
Returns: hello

capitalize (text)

Converts the first character in a text string to uppercase.

INFO
Example:
capitalize( workfront )
Returns: Workfront

startcase (text)

Capitalizes the first letter of every word and lower cases all other letters.

INFO
Example:
startcase( hello WORLD )
Returns: Hello World

ascii (text; [remove diacritics])

Removes all non-ascii characters from a text string.

INFO
Examples:

  • ascii( 奥臎辞拧谤膷办艡蹿啪谤媒辞谩苍铆迟茅 )

    Returns: Workfront

  • ascii( 臎拧膷艡啪 ; true )

    Returns: escrz

replace (text;search string; replacement string)

Replaces the search string with the new string.

INFO
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:

INFO
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.
  • $n Where n is a positive integer less than 100, inserts the nth parenthesized submatch string. This is 1-indexed.
INFO
Examples:
Returns: Phone number +420777111222
Returns: Phone number: +420777111222
CAUTION
Do not use named capture groups such as / 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.

INFO
Example:
upper( Hello )
Returns: HELLO

substring (text; start;end)

Returns a portion of a text string between the 鈥渟tart鈥 position and 鈥渆nd鈥 position.

INFO
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.

INFO
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.

INFO
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.

INFO
Example:
decodeURL( Automate%20your%20workflow )
Returns: Automate your workflow

escapeHTML (text)

Escapes all HTML tags in text.

INFO
Example:
escapeHTML( <b>Hello</b> )
Returns: &lt;b&gt;Hello&lt;/b&gt;

escapeMarkdown(text)

Escapes all Markdown tags in text.

INFO
Example:
escapeMarkdown( # Header )
Returns: # Header

stripHTML (text)

Removes all HTML tags from text.

INFO
Example:
stripHTML( <b>Hello</b> )
Returns: Hello

contains (text; search string)

Verifies whether text contains the search string.

INFO
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.

INFO
Example:
split( John, George, Paul ; , )

md5 (text)

Calculates the md5 hash of a string.

INFO
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: 鈥渉别虫鈥 (default), 鈥渂补蝉别64鈥 or 鈥渓atin1.鈥

INFO
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: 鈥渉别虫鈥 (default), 鈥渂补蝉别64鈥 or 鈥渓补迟颈苍1鈥.>

INFO
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:

  • 鈥渉别虫鈥 (default)
  • 鈥渂补蝉别64鈥
  • 鈥渓补迟颈苍1鈥

Supported key encodings:

  • 鈥渢ext鈥 (default)
  • 鈥渉别虫鈥
  • 鈥渂补蝉别64鈥 or 鈥渂inary鈥

When using 鈥渂inary鈥 key encoding, a key must be a buffer, not a string.

INFO
Example:
sha512(workfront)
Returns: 789ae41b9456357e4f27c6a09956a767abbb8d80b206003ffdd1e94dbc687cd119b85e1e19db58bb44b234493af35fd431639c0345aadf2cf7ec26e9f4a7fb19

base64 (text)

Transforms text to base64.

INFO
Example:
base64( workfront )
Returns: d29ya2Zyb250==
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43