String Functions

beginsWith(string, sub)

Returns true if the first string begins with the second. So,

beginsWith("South Dakota", "South") returns true

beginsWith("William", "won't") returns false

beginsWith(600/6, 1) returns true

beginsWith("hypothesis", "H") returns true (because the function is not case sensitive)

concat(str1, str2, …)

Concatenates the given strings (puts them together) into a single string. You can use literal strings (with quotes) or attributes, in which case the values get put into the strings. This function can take up to 10 arguments, that is, you can write

concat("I am ", age, " years old. I like ", faveFood, " but I hate ", yuckFood)

and so forth. The above might give you

I am 9 years old. I like broccoli but I hate butternut squash

endsWith(string, sub)

Returns true if the first string ends with the second. So,

endsWith("San Francisco", "Cisco") returns true (not case sensitive)

endsWith("My daughter is sick!", ".") returns false

endsWith(600/6, 0) returns true

endsWith(Sport, "ing") returns true if Sport is "swimming" but false if sport is "track and field"

includes(string, sub)

Returns true if the second string is a substring of the first.
Example: includes("the", "he") gives true.

(If you can't find this function in String, look in Logical).

stringLength(string)

Returns the number of characters in the given string.

stringLength("mathematics") returns 11

stringLength("I like to dance!") returns 16 (spaces count)

stringLength(Name) returns 3 if Name is "Bob" or 7 if Name is "Djenaba"

stringToNumber(string)

Returns the first number found in parsing the string from left to right. Examples:

stringToNumber("$49.01") returns 49.01

stringToNumber("April 3, 1911") returns 3

stringToNumber("a-3.14") returns -3.14

 

Categories of Functions