len()

Returns the number of characters in the string.

len(string)

Leading and trailing whitespace characters are included in the length returned. Returns null if string is null.

1len("starfox") == 7
2len(" rocket ") == 8
3len("謝") == 1
4len("") == 0

j

Overview

Quick Start

Examples

SAQL Reference

SAQL Basic Elements

SAQL Operators

SAQL Statements

SAQL Functions

Aggregate Functions

Date Functions

Time Zone Date Functions

Work with Custom Fiscal Year Data

String Functions

ascii()

chr()

ends_with()

index_of()

len()

lower()

ltrim()

mv_to_string()

number_to_string

replace()

rtrim()

starts_with()

string_to_number

substr()

trim()

upper()

Math Functions

Windowing Functions

coalesce

Query Performance

Previous Versions