[SOLVED] Adding a phone number field (XXX) XXX-XXXX

Hello all. This is most likely the effects of another long day, but I can't, for the life of me, figure out how to add a field that displays a phone number on the user's profile, with the following format: (XXX) XXX-XXXX

I know this has been answered before with:
Regex:
[code:1]
\(?\b[0-9]{3}\)?[-. ]?[0-9]{3}[-. ]?[0-9]{4}\b
[/code:1]

Matches:
5555555555
555.555.5555
555-555-5555
555 555-5555
(555) 555-5555
But what I'm looking for is a set value or (###) ###-#### without allowing other options like ###.###.#### or ### ###-####. I'm shooting for a consistent look that isn't determined by the users input decisions.

Any suggestions would be appreciated.

Thanks!

Only way to apply formatting to a field is to use CB Query Field then query the database for the field and format it using SQL functions. Alternative is to develop a new CB plugin that uses CB triggers to parse through fields display functions and alters the output.

Thanks for your response Kyle. You're trying to tell me something..... I just know it.

does anyone have sample code to put in the query. Someone out there has had to have done this before. I'm the furthest thing there is from a coder, but guidance gets me a long ways.

The below should work.


It'll format to 000-000-0000. Adjust as needed. Note I have not tested it so I've no idea if it'll actually work, but is just a guess based off SQL function usages.

Please see the below links for understanding of the functions used.

CONCAT: dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_concat
LEFT: dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_left
MID: dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_mid
RIGHT: dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_right

That worked like a champ. You'll be happy to know I am enrolling in a few classes this semester to help me better understand SQL and databases in general. In the meantime, I appreciate your guidance.