Articles on: Connectors

Function Expressions - Text

Overview


TBD

Variables


UUID


RFC 4122 version 4 compliant unique identifier
Syntax: uuid()


List of Functions


Length


Returns the length of a text string (number of characters) or binary buffer (buffer size in bytes)
Syntax: lengthString(value)


Lower


Converts all alphabetical characters in a text string to lowercase
Syntax: lower(text)


Capitalize


Converts first character in a text string to uppercase
Syntax: capitalize(text)


Startcase


Capitalizes the first letter of every word and lower cases all other letters
Syntax: startcase(text)


ASCII


Removes all non-ascii characters from a text string
Syntax: ascii(text, [remove diacritics])


Replace


Replaces part of a text string with a different text string
Syntax: replace(text, search, new_text)


Trim


Removes space characters at the start or end of the text
Syntax: trim(text)


Upper


Converts all alphabetical characters in a text string to uppercase
Syntax: upper(text)


Substring


Returns a portion of a text string between the 'start' position and 'the end' position
Syntax: substring(text, start, end)



indexOf


Returns the position of the first occurrence of a specified value in a string. This method returns '-1' if the value searched for never occurs
Syntax: indexOf(string, value, start)


Encode


Encode to Base64 format. You can also specify the character set as argument. Default (utf-8). example: Encode(<data to convert>,<utf-8>)
Syntax: Encode(value,charcterset)


Decode


Decode from Base64 format. You can also specify the character set as argument. Default (utf-8). example: Decode(<encoded data to convert>,<utf-8>). For Safe url decode use (safe) as character-set.
Syntax: Decode(value,charcterset)


toString


Converts any value to a string
Syntax: toString(value)


toDic


Converts string to a list or dictionary
Syntax: toDic(value)


toSchema


Generate a JSON Schema from JSON
Syntax: toSchema(value)


encodeURL


Encodes special characters in a text to a valid URL address
Syntax: encodeURL(text)


decodeURL


Decodes special characters in URL to text
Syntax: decodeURL(text)


escapeHTML


Escapes all HTML tags in text
Syntax: escapeHTML(text)


stripHTML


Removes all HTML tags from text
Syntax: stripHTML(text)



Contains


Verifies if text contains the search string
Syntax: contains(text, search)


Split


Splits a string into an array of substrings split at each point where the separator occurs in the given string. If the keepEmptyString is true, empty substrings are preserved in the array
Syntax: split(text, separator, keepEmptyString)



md5


Calculates the md5 hash of a string
Syntax: md5(text)



sha1


Calculates the sha1 hash of a string. If the key argument is specified, sha1 HMAC hash is returned instead. Supported output encodings: hex (default), base64 or latin1. Supported key encodings: text (default), hex, base64 or binary. When using binary key encoding, a key must be a buffer, not a string
Syntax: sha1(text, [output encoding], [key], [key encoding])


sha256


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. Supported key encodings: text (default), hex, base64 or binary. When using binary key encoding, a key must be a buffer, not a string
Syntax: sha256(text, [output encoding], [key], [key encoding])



Keywords


Space


Inserts a space character in a specific location

Tab


Inserts a tab character in a specific location

Empty Text


Inserts an empty text in a specific location

New Line


Inserts a new line character in a specific location

Carriage return


Inserts a carriage return character in a specific location

Updated on: 25/07/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!