Scalar FunctionsString Functions
substring
Extracts a substring from the source string starting at the specified position.
Syntax
substring(source, startingIndex, length)Parameters
Prop
Type
Given a dynamic field
This parameter is string-only. In permissive mode — the default — almost every field arrives as a dynamic, so passing one works because Berserk injects asstring: extract-or-null, the value when it really is a string and null otherwise, so the call yields null (a predicate yields false). A property bag or array is therefore not matched, and tostring() is never applied implicitly — use it explicitly to match a bag's JSON text, keys included. Strict mode rejects the dynamic instead of coercing it. See String coercion and the asXXX family.
Returns: string
Examples
Example 1
print substring("Lothbrok", 4)| print_0 (string) |
|---|
| brok |
Example 2
print substring("Ragnar", 0, 3)| print_0 (string) |
|---|
| Rag |
Example 3
print substring("Kattegat", 2, 4)| print_0 (string) |
|---|
| tteg |
Example 4
print substring("Berserker", -3, 3)| print_0 (string) |
|---|
| ker |