Description
Searches for and returns a continuous string of numeric characters from within an item of text
Syntax
EXTRACTNUMERIC(<input>)
Arguments
| Argument |
Type |
Description |
Optional |
| input |
Text |
The text to search |
No |
| minlength |
Integer |
The minimum number of (sequential) digits to find to qualify as a match |
No |
| index |
Integer (zero based) |
Which match to return in the event of multiple matches being found |
Yes – Default = 0 |
Returns
Text
Examples
| Expression: |
EXTRACTNUMERIC("Here's my phone number: 0123456789", 10) |
| Returns: |
0123456789 |
| Expression: |
EXTRACTNUMERIC("Here's my phone number: 0123456789 and my mobile: 07123456789", 10) |
| Returns: |
0123456789 |
| Expression: |
EXTRACTNUMERIC("Here's my phone number: 0123456789 and my mobile: 07123456789", 10, 1) |
| Returns: |
07123456789 |
Download
Download Example
