Source Links Transformation Reference

Split

The split function splits a string of text using a specified delimiter and recombines some or all of the string without the delimiter. It is comprised of two parameters:

• The string separator, or a set of characters that are used to split a string
• (optional) A recombination variable, which specifies which parts of the string should be recombined without the delimiter.

Function syntax:

split('delimiter'[,Recombination])

The string separator must be wrapped in single or double quotes (' or ")

• The Recombination parameter is optional, with the following values:
  • 0: Recombine all non-separator characters
  • 1: Return the set of characters before the first separator character
  • 2: Recombine all non-separator characters
• If no recombination parameter is specified, all non-separator characters will be recombined

Examples: A field formatted like a-b-c (with the hyphen being the separator) can be split in any of the following ways:

• split('-') or split('-',0): outputs abc
• split('-',1): outputs a
• split('-',2): outputs bc

Prefix

The prefix function can add or remove a prefix from a string of text. It is comprised of two parameters:

• A string of text
• (optional) a strip boolean, which specifies whether the string should be added to or removed from the beginning of the linked field

Function syntax:

prefix('string'[,strip=true/false])

A string being added to or removed from the beginning of the linked field

• The strip parameter is optional, with the following values:
  • true: The string will be removed to the beginning of the linked field when true is specified
  • false: The string will be added to the beginning of the linked field when false is specified
• If no strip parameter is specified, the string will be added to the beginning of the linked field

Examples:

• To add a string “ABC” to the beginning of a linked field: prefix('ABC',strip=false) or `prefix('ABC')
• To remove a string “ABC” from the beginning of a linked field: prefix('ABC',strip=true)

Suffix

The prefix function can add or remove a suffix from a string of text. It is comprised of two parameters:

• A string of text
• (optional) a strip boolean, which specifies whether the string should be added to or removed from the end of the linked field

Function syntax:

suffix('string'[,strip=true/false])

• A string being added to or removed from the beginning of the linked field
• The strip parameter is optional, with the following values:
  • true: The string will be removed to the end of the linked field when true is specified
  • false: The string will be added to the end of the linked field when false is specified
• If no strip parameter is specified, the string will be added to the end of the linked field

Examples:

• To add a string “ABC” to the end of a linked field: suffix('ABC',strip=false) or `suffix('ABC')
• To remove a string “ABC” from the end of a linked field: suffix('ABC',strip=true)

Lowercase

This function converts all uppercase letters in a string to be lowercase

Function syntax:

lowercase

Example: When lowercase is used, a string like ExAmpleSTring will be converted to examplestring

Uppercase

This function converts all lowercase letters in a string to be uppercase.

Function syntax:

uppercase

Example: When uppercase is used, a string like ExAmpleSTring will be converted to EXAMPLESTRING

String-to-integer

This function converts a field’s datatype from Integer to String.

Function syntax:

string_to_int

Integer-to-string

This function converts a field’s datatype from String to Integer

Function syntax:

int_to_string

Replace (Regular Expression)

This function replaces characters defined using a regular expression with defined characters

Function syntax:

regex_replace(regular_expression,'replacement_string')

• For reference, a Regular Expression dictionary can be found here: https://docs.python.org/3/library/re.html
• The replacement string must be contained in single quotes (') or double quotes (")

Examples:

• To remove all non-numeric characters from a string of text, use: regex_replace('[^0-9]','')
• To replace any hyphen (-) with a period, use: regex_replace('-','\.')