Remember that character indices start from zero. For example, "profound".substring(3) returns the string “found”, and "profound".substring(2, 4) returns the string “of”. If the to argument is omitted, substring will output to the end of s. Returns the substring of s starting from character index from, and up to (excluding) character index to. Substring substring(s, n from, n to (optional)) For example, "barely".chomp("ly") and "bare".chomp("ly") both return the string “bare”. Returns a copy of string s with the string sep removed from the end if s ends with sep otherwise, just returns s. For example, " island ".strip() returns the string “island”.
Returns a copy of the string s with leading and trailing whitespace removed. For example, " island ".trim() returns the string “island”. For example, "Once upon a midnight DREARY".toTitlecase() returns the string “Once Upon A Midnight Dreary”. Returns string s converted into titlecase: a capital letter starting each word, and the rest of the letters lowercase. Returns string s converted to all uppercase characters. Returns string s converted to all lowercase characters. Basic string modification Case conversion toLowercase(s) startsWith() and endsWith() can only take strings, while contains() can take a regex pattern, so you can use contains() to look for beginning and ending string patterns. You can search for a regular expression by wrapping it in forward slashes rather than quotes: "rose is a rose".contains(/\s+/) returns true. For example, "food".contains("oo") returns true whereas "food".contains("ee") returns false. Returns a boolean indicating whether s contains sub, which is either a substring or a regex pattern. For example, "food".endsWith("ood") returns true, whereas "food".endsWith("odd") returns false. Returns a boolean indicating whether s ends with sub. For example, "food".startsWith("foo") returns true, whereas "food".startsWith("bar") returns false. Returns a boolean indicating whether s starts with sub. Testing string characteristics startsWith(s, sub) Note: In OpenRefine, using toString() on a null cell outputs the string “null”.
For example, value.toString("MMM-dd-yyyy") would convert the date value to “Oct-15-2024”. You can also convert dates to strings, using date parsing syntax built into OpenRefine (see the toDate() function for details). For example, if you applied the expression value.toString("%.0f") to a column: Input You can use toString() to convert numbers to strings with rounding, using an optional string format. Takes any value type (string, number, date, boolean, error, null) and gives a string version of that value. Returns the length of string s as a number. For example, (1 < 3).xor(1 < 7) returns false because more than one of the conditions is true. Evaluates multiple statements, then returns true if only one of them is true. Uses the logical operator XOR (exclusive-or) on two or more booleans to output a boolean.
For example, not(1 > 7) returns true because 1 > 7 itself is false. Uses the logical operator NOT on a boolean to output a boolean. For example, (1 7) returns true because at least one of the conditions (the first one) is true. Evaluates multiple statements into booleans, then returns true if all of the statements are true. Uses the logical operator AND on two or more booleans to output a boolean. If you wish to use any regex notation, wrap the pattern in forward slashes. In places where OpenRefine will accept a string (s) or a regex pattern (p), you can supply a string by putting it in quotes. Optional arguments will say “(optional)”. We also use shorthands for substring (“sub”) and separator string (“sep”). If a function can take more than one kind of data as input or can output more than one kind of data, that is indicated with more than one letter (as with “s or a”) or with o for object, meaning it can take any type of data (string, boolean, date, number, etc.). Shorthands are used to indicate the kind of data type used in each function: s for string, b for boolean, n for number, d for date, a for array, p for a regex pattern, and o for object (meaning any data type), as well as “null” and “error” data types. For the reference below, the function is given in full-length notation and the in-text examples are written in dot notation.
0 kommentar(er)
