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