AXEL Text Functions
📝 Text Manipulation & Conversion
7 functions for string operations and type conversions.
UPPER
Convert text to uppercase.
UPPER("hello")
Returns: "HELLO"
Use Cases: Standardization, case-insensitive comparisons
LOWER
Convert text to lowercase.
LOWER("HELLO")
Returns: "hello"
Use Cases: Normalization, consistent formatting
TRIM
Remove leading and trailing spaces.
TRIM(" hello ")
Returns: "hello"
Use Cases: Data cleaning, input sanitization
LEN
Get string length (character count).
LEN("hello world")
Returns: 11
Use Cases: Validation, text analysis
TEXT
Convert value to text string.
TEXT(123.45)
Returns: "123.45"
Use Cases: Display formatting, concatenation
INT
Convert to integer (whole number).
INT(123.89)
Returns: 123
Use Cases: Removing decimals, counting
FLOAT
Convert text to floating-point number.
FLOAT("123.45")
Returns: 123.45 (numeric)
Use Cases: Parsing strings, calculations
💡 Practical Examples
Standardize Names
UPPER(TRIM([CustomerName]))
Validate Input Length
IF(LEN([Input]) > 50, "Too Long", "OK")
Clean Numeric Strings
FLOAT(TRIM([PriceText]))
Format for Display
"Total: " & TEXT(ROUND([Amount], 2))
📊 Common Patterns
Data Cleaning Pipeline
UPPER(TRIM([TextField])) -- Standardize
LEN([TextField]) > 0 -- Validate non-empty
Type Conversion Safety
IFERROR(FLOAT([TextValue]), 0)
String Analysis
LEN([Description]) / COUNT([Words]) -- Avg word length