SUBSTR

 ──SUBSTR(string,n ─┬───────────────────────┬─)─────
                      └─,─┬────────┬─┬──────┬─┘
                          └─length─┘ └─,pad─┘

SUBSTR returns the substring of string that begins at the nth character, and is of length length and padded with pad if necessary. n must be a positive whole number.

If length is omitted, the rest of the string will be returned. The default pad character is a blank.

Here are some examples:

SUBSTR('abc',2)          ->    'bc'
SUBSTR('abc',2,4)        ->    'bc  '
SUBSTR('abc',2,6,'.')    ->    'bc....'

┴╓: In some situations the positional (numeric) patterns of parsing templates are more convenient for selecting substrings, especially if more than one substring is to be extracted from a string.

---

[Back: STRIP]
[Next: SUBWORD]