Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Forcing a Field to a Specific Format

Quote Reply
Forcing a Field to a Specific Format
I have a phone number and fax number field within my database. People will enter all of the following formats:

(xxx) xxx-xxxx
xxx-xxx-xxxx
xxx xxx xxxx
xxx xxx-xxxx

Is there any way to take any data input into these fields and force it to my desired format of xxx-xxx-xxxx (as long as it has 10 digits)?

Thanks.

Subject Author Views Date
Thread Forcing a Field to a Specific Format Canucks 1194 Jul 15, 2000, 10:16 AM
Thread Re: Forcing a Field to a Specific Format
Stealth 1153 Jul 15, 2000, 11:41 AM
Thread Re: Forcing a Field to a Specific Format
Canucks 1155 Jul 15, 2000, 11:54 AM
Post Re: Forcing a Field to a Specific Format
Stealth 1148 Jul 15, 2000, 12:48 PM