Text Formulas

Formulas

  1. Concat

  2. Skip

Concat

Formula

=concat(input, [input, ...])

Description

Concatenates all given inputs from left to right.

Arguments

Argument

Required (Y/N)

Description

Input

Y

The input to which following inputs will be appended

Input

N

The second and any additional inputs to append to the first input

Examples

Example 1:

=concat($"FirstName", "-", $"LastName") = Albert-Einstein

Example 2:

=concat("a","b","C","D") = abCD

Skip

Formula

=skip()

Description

Skips the given row.

Arguments

Argument

Required (Y/N)

Description

N/A

N/A

N/A

Examples

Example 1:

= if(equals($"Cost", 0), skip(), $"Cost") = [skips row OR lists cost]

Skipping a row means the row will not be included in the output.

ToCamelCase

Formula

=tocamelcase(input)

Description

Converts the input to camel case.

Arguments

Argument

Required (Y/N)

Description

Input

Y

Text input to be converted to camel case.

Examples

Example 1:

=tocamelcase("First Name") = firstName

Example 2:

=tocamelcase("Product Identifier") = productIdentifier

ToClassCase

Formula

=toclasscase(input)

Description

Converts the input to class case.

Arguments

Argument

Required (Y/N)

Description

Input

Y

Text input to be converted to class case

Examples

Example 1:

=toclasscase("first name") = FirstName

Example 2:

=toclasscase("product identifier") = ProductIdentifier

ToKebabCase

Formula

=tokebabcase(input)

Description

Converts the input to kebab case, replacing spaces between words with a "-" and converts all text to lower case.

Arguments

Argument

Required (Y/N)

Description

Input

Y

Text input to be converted to kebab case

Examples

Example 1:

=tokebabcase("First Name") = first-name

Example 2:

=tokebabcase("product description") = product-description

Example 3:

=tokebabcase("Product ID") = product-id

ToLowerCase

Formula

=tolowercase(input)

Description

Converts the text input to lower case.

Arguments

Argument

Required (Y/N)

Description

Input

Y

Text input to be converted to lower case

Examples

Example 1:

=tolowercase("First Name") = first name

Example 2:

=tolowercase("Product Identifier") = product identifier

ToScreamingSnakeCase

Formula

=toscreamingsnakecase(input)

Description

Converts the text input to screaming snake case by replacing all lowercase with uppercase and replacing spaces with underscores.

Arguments

Argument

Required (Y/N)

Description

Input

Y

Text input to be converted to screaming snake case

Examples

Example 1:

=toscreamingsnakecase("First Name") = FIRST_NAME

Example 2:

=toscreamingsnakecase("Product identifier") = PRODUCT_IDENTIFIER

ToSentenceCase

Formula

=tosentencecase(input)

Description

Converts the text input to sentence case by replacing the first letter of the input text with an uppercase letter and replacing dashes or underscores with spaces.

Arguments

Argument

Required (Y/N)

Description

Input

Y

Text input to be converted to sentence case

Examples

Example 1:

=tosentencecase("first Name") = First name

Example 2:

=tosentencecase("PRODUCT_IDENTIFIER") = Product identifier

ToSnakeCase

Formula

=tosnakecase(input)

Description

Converts the text input to snake case by replacing all uppercase with lowercase and replacing spaces with underscores.

Arguments

Argument

Required (Y/N)

Description

Input

Y

Text input to be converted to snake case

Examples

Example 1:

=tosnakecase("First NAME") = first_name

Example 2:

=tosnakecase("Product-ID") = product_id

ToTitleCase

Formula

=totitlecase(input)

Description

Converts the text input to title case by replacing all first letters of words with uppercase and replacing any underscores and dashes with spaces.

Arguments

Argument

Required (Y/N)

Description

Input

Y

Text input to be converted to title case

Examples

Example 1:

=totitlecase(currentdatetime(, "the day of the week is %a") = The Day Of The Week Is Fri

Example 2:

=totitlecase("product_identifier") = Product Identifier

ToTrainCase

Formula

=totraincase(input)

Description

Converts the text input to train case by replacing all first letters of words with uppercase and replacing any underscores and spaces with dashes.

Arguments

Argument

Required (Y/N)

Description

Input

Y

Text input to be converted to train case

Examples

Example 1:

=totraincase("First name") = First-Name

Example 2:

=totraincase("Product_identifier") = Product-Identifier

ToUpperCase

Formula

=touppercase(input)

Description

Converts the text input to upper case.

Arguments

Argument

Required (Y/N)

Description

Input

Y

Text input to be converted to upper case

Examples

Example 1:

=touppercase("First Name") = FIRST NAME

Example 2:

=touppercase("Product-identifier") = PRODUCT-IDENTIFIER