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 |