Script to delete non-numeric characters

[Johnny777]

Can anyone give me a simple script which searches thru a given text field and strips out any character accept numbers (zero to nine). Leaving only the numbers in the field.

Many thanks

[javabandit]

This should do it:

Set Variable [$var; Value: Filter(table::fieldname ; "0123456789" )]

Set Field [table::fieldname ; $var ]

[comment]

Or just:

Set Field [ table::fieldname ; Filter ( table::fieldname ; "0123456789" ) ]

[Johnny777]

Second one worked a treat

Many thanks for both replies