Phone, SSN, and other formats

[vinsnash]

I saw some discussion of this on old posts. Is it possible now to force numeric editing for phones, and other numbers?

Example:


Phone: (999) 999-9999
SSN: 999-99-9999

I'm looking for a way to allow the user to enter the digits and the system to group and supply the dashes and parens.

All help appreciated.

[tford]

vinsnash,

I'm not sure of your exact requirements, but an easy way would be to have 2 attributes:

1a- PhoneInput - text 10
1b- Phone - text 13

You can then make a rule:
Customer.Phone='('+SUBSTRING(Customer.PhoneInput,0,3)+')'+SUBSTRING(Customer.PhoneInput,3,6)+'-'+SUBSTRING(Customer.PhoneInput,6,10)

Hope this helps.
Tom

[greg]

A user may enter their own dashes and spaces, therefore I would add an intermediate attribute where you store a phone number cleaned up of user's non-numerical input

1aa - PhoneInputShort

and a rule

PhoneInputShort=REPLACE_PATTERN(PhoneInput,'[ .-]','')

Then use this PhoneInputShort in further formatting

[vinsnash]

A little late getting back. But thanks all that's very helpful.