Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try
Returns the string s1 less all characters not contained in string s2.
keepchar ( 'a1b2c3def','1234567890' ) returns '123'
try
Returns the string s1 less all characters not contained in string s2.
keepchar ( 'a1b2c3def','1234567890' ) returns '123'
Thanks Alex- got it working