Copying data from one field to another

[Matt Leach]

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

[Lee Smith]

Filter (yourField; "0123456789")

You can also use the substitute function

Substitute (yourField; "-"; "")

Edited November 9, 2009 by Guest
added Substitute

[Matt Leach]

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

[Matt Leach]

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!

[Lee Smith]

Either one can be used in a script.

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