I have a text field called notes in which users have typed almost anything they like.
I need to find numeric data randomly inserted in there.
So for example there may be a telephone number and an account number
in amongst varied text.
How do I extract this data in a SELECT query in the format
OR
I have found a function called ExtractInteger( )
which returns the numeric data in the format
Nearly there but not quite.
I suppose in the meantime I will try to improve on this function
unless someone has a solution
I need to find numeric data randomly inserted in there.
So for example there may be a telephone number and an account number
in amongst varied text.
How do I extract this data in a SELECT query in the format
Code:
id number xx 0107364561 2124
Code:
id number xx 0107364561 xx 2124
which returns the numeric data in the format
Code:
01073645612124.
I suppose in the meantime I will try to improve on this function
unless someone has a solution
Comment