extract number()
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 |