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 ?
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.
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.
Thanks to raybaudi and PhilModJunk. Now It's working :)
Retrieving data ...