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. |
Next steps: