LEN / UPPER / SUBSTR
Try it yourself →Length, uppercase, substring.
Syntax
LEN(s) · UPPER(s) · SUBSTR(s, start, length)
Description
LEN length, UPPER/LOWER case conversion, SUBSTR(s,1,3) first 3 characters (1-indexed), AT position.
Example
? LEN("hello")
? UPPER("hello")
? SUBSTR("HexLibrary", 1, 3)Expected output
5 HELLO Hex
When to use?
Text processing.