Replacing
|
Replaces all occurrences of a String within another String. |
|
Replaces a String with another String inside a larger String, for the first max values of the search String. |
|
Replaces a String with another String inside a larger String, once. |
Samples
number decimal separator to "."
return replace(value(), ".", ",")
Trimming and whitespaces cleaning
|
Strips any of a set of characters from the start and end of a String. |
|
Strips whitespace from the start and end of every String in an array. |
|
Strips any of a set of characters from the start and end of every String in an array. |
|
Strips any of a set of characters from the end of a String. |
|
Strips any of a set of characters from the start of a String. |
|
Removes control characters (char <= 32) from both ends of this String, handling null by returning null. |
|
Removes one newline from end of a String if it's there, otherwise leave it alone. |
|
Removes separator from the end of str if it's there, otherwise leave it alone. |
|
Deletes all whitespaces from a String. |
Samples
Basic trimming of all whitespaces after and before cell content:
return trim(value());
Case manipulation
|
Swaps the case of a String changing upper and title case to lower case, and lower case to upper case. |
|
Uncapitalizes a String changing the first letter to title case. |
|
Converts a String to lower case as per String.toLowerCase(). |
|
Converts a String to upper case. |