I currently have a phone number field in my database which is in the standard phone number format = xxx-xxx-xxxx

I have a script that will copy the data in the phone number field into a PID field which works, but i was wondering how i could script this to remove the hyphens.

So for example the phone number field would read 123-456-7891. Once copied, it should read 1234567891.

Thanks

Filter (yourField; "0123456789")

You can also use the substitute function

Substitute (yourField; "-"; "")

Edited November 9, 200916 yr by Guest
added Substitute

Would that be a calculation set on the field or included in my script to copy the data from the field?

Thank you for your response, after looking at the substitue line you added, it now makes sense and ive added to my scrit as setting the PID field as:

Substitute ( $PID ;"-" ; "" )

Works great, Thanks again!

Either one can be used in a script.

Set Field [Field2; Filter (Field1 ; 123456789 ) ]