Text Formulas

Formulas
1.​Concat​
2.​Find​
3.​Len​
4.​Replace​
5.​Skip​
6.​ToCamelCase​
7.​ToClassCase​
8.​ToKebabCase​
9.​ToScreamingSnakeCase​
10.​ToSentenceCase​
11.​ToSnakeCase​
12.​ToTitleCase​
13.​ToTrainCase​
14.​ToUpperCase​
15.​Trim​
16.​Truncate​
17.​rTruncate​
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(quot;FirstName", "-", quot;LastName") = Albert-Einstein
Example 2:
=concat("a","b","C","D") = abCD
Find
Formula
=find(input, searchTerm)
Description
Returns the zero-based index of the given search term or null if it is not found.
Arguments
Argument
Required (Y/N)
Description
input
Y
The string to search within
searchTerm
Y
The search term to search for
Examples
Example 1:
=find("tacocat", "taco") => 0
Example 2:
=find("tacocat", "cat") => 4
Example 3:
=find("tacocat", "dog") => null
Len
Formula
=len(input)
Description
Returns the length of a given input.
Arguments
Argument
Required (Y/N)
Description
input
Y
Input to find the length of
Examples
Example 1:
=len("tacocat") => 7
Example 2:
=len("") => 0
Replace
Formula
=replace(input, searchTerm, replacement)
Description
Replaces any found occurrences of the search term with the replacement string.
Arguments
Argument
Required (Y/N)
Description
input
Y
The string to search and replace within
searchTerm
Y
Substring to search for
replacement
Y
Substring to replace occurrences of the search term with
Examples
Example 1: 
=replace("tacocat", "taco", "burrito") => "burritocat"
Example 2:
=replace("tacocat", "taco", "") => "cat"
Example 3:
=replace("tacocat", "cat", "dog") => "tacodog"
Example 4:
=replace("tacocat", "dog", "horse") => "tacocat"
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(quot;Cost", 0), skip(), quot;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
Trim
Formula
=trim(input)
Description
Trims whitespace around a string. Does not trim whitespace in between characters.
Arguments
Argument
Required (Y/N)
Description
input
Y
String to remove surrounding whitespace from
Examples
Example 1:
=trim(" taco ") => "taco"
Example 2:
=trim(" taco cat ") => "taco cat"
 Example 3:
=trim("taco cat") => "taco cat"
Truncate
Formula
=truncate(input, number)
Description
Truncates text input to a specific length cutting off excess characters from the end.
Arguments
Argument
Required (Y/N)
Description
Input
Y
Text input to be truncated
Number
Y
The number of digits from the end to truncate the Input to
Examples
Example 1:
=truncate("tacocat",4) = taco
Example 2:
=truncate("Wed Mar 07 2018 19:57:53 GMT-0500 (Eastern Standard Time)", 33) = Wed Mar 07 2018 19:57:53 GMT-0500 
​
rTruncate
Formula
=rtruncate(input, number)
Description
Truncates a given input to a specific length, cutting off excess characters from the beginning.
Arguments
Argument
Required (Y/N)
Description
Input
Y
Text input to be truncated
Number
Y
The number of digits from the beginning to truncate the Input to
Examples
Example 1:
=rtruncate("tacocat",4) = ocat
Example 2:
=rtruncate(quot;Date",4) 
​
​