This function extracts all numbers out of a character sequence a. If the string contains no numbers, the return value is 0, see examples below.
Parameter a can have the following data types: String, BigDecimal, Blob.
Parameters
Parameter | Description |
|---|---|
a | Value. |
Examples
Parameter a | Result |
|---|---|
abc123de45zz | 12345 |
123 | 123 |
abc | 0 |
123.45 | 12345 |