Example 1:=concat(quot;FirstName", "-", quot;LastName") = Albert-EinsteinExample 2:=concat("a","b","C","D") = abCD
Example 1:=find("tacocat", "taco") => 0Example 2:=find("tacocat", "cat") => 4Example 3:=find("tacocat", "dog") => null
Example 1:=len("tacocat") => 7Example 2:=len("") => 0
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"
Example 1:= if(equals(quot;Cost", 0), skip(), quot;Cost") = [skips row OR lists cost]
Example 1:=tocamelcase("First Name") = firstNameExample 2:=tocamelcase("Product Identifier") = productIdentifier
Example 1:=toclasscase("first name") = FirstNameExample 2:=toclasscase("product identifier") = ProductIdentifier
Example 1:=tokebabcase("First Name") = first-nameExample 2:=tokebabcase("product description") = product-descriptionExample 3:=tokebabcase("Product ID") = product-id
Example 1:=tolowercase("First Name") = first nameExample 2:=tolowercase("Product Identifier") = product identifier
Example 1:=toscreamingsnakecase("First Name") = FIRST_NAMEExample 2:=toscreamingsnakecase("Product identifier") = PRODUCT_IDENTIFIER
Example 1:=tosentencecase("first Name") = First nameExample 2:=tosentencecase("PRODUCT_IDENTIFIER") = Product identifier
Example 1:=tosnakecase("First NAME") = first_nameExample 2:=tosnakecase("Product-ID") = product_id
Example 1:=totitlecase(currentdatetime(, "the day of the week is %a") = The Day Of The Week Is FriExample 2:=totitlecase("product_identifier") = Product Identifier
Example 1:=totraincase("First name") = First-NameExample 2:=totraincase("Product_identifier") = Product-Identifier
Example 1:=touppercase("First Name") = FIRST NAMEExample 2:=touppercase("Product-identifier") = PRODUCT-IDENTIFIER
Example 1:=trim(" taco ") => "taco"Example 2:=trim(" taco cat ") => "taco cat"Example 3:=trim("taco cat") => "taco cat"
Example 1:=truncate("tacocat",4) = tacoExample 2:=truncate("Wed Mar 07 2018 19:57:53 GMT-0500 (Eastern Standard Time)", 33) = Wed Mar 07 2018 19:57:53 GMT-0500
Example 1:=rtruncate("tacocat",4) = ocatExample 2:=rtruncate(quot;Date",4)