Search a field and remove the letters

[#1]

Hi,

I'm trying to remove all the alphabetic characters so that it will leave me with the number from a field.

Eg. field contains "Loaded as of 14/12/2009, status complete" and I am looking for the date.

I have tried using findoneof but I can't seem to be able to get the date from the field.

Am I on the right track here? Does anyone know of a better way to do this?

Any help is much appreciated.
McKay

[#2 · Accepted solution]

try

KeepChar( s1 , s2 )

Returns the string s1 less all characters not contained in string s2.

Example:

keepchar ( 'a1b2c3def','1234567890' ) returns '123'

[#3]

Thanks Alex- got it working