Ignore dashes and spaces

Hi. Can a number field ignore dashes and spaces? The field is for identity card number. Sometimes people put in their IC number with dashes, spaces. Can the field ignore the dashes and spaces ?

Thanks

Hi

use the Filter ( ) function in an auto-enter calculation for that field, something like:

Filter ( Self ; 1234567890 )

If I want to filter (-) how the calculation would be? I tried to do it but I got some error.

Use this expression as an auto-entered calculation. Clear the "do not replace existing value..." option when you set it up.

THis autmoatically removes all but the numeric digits, so it becomes a self correcting field.

Thanks to raybaudi and PhilModJunk. Now It's working :)

Use this expression as an auto-entered calculation. Clear the "do not replace existing value..." option when you set it up.

THis autmoatically removes all but the numeric digits, so it becomes a self correcting field.