Need a new data mask

So DW8 already has the behaviors built in to take data from a recordset, and
format it (like date, or numbers) .. but I need it to be able to take the 10
digits from the particular field, and format it as a phone number: (xxx)
xxx-xxxx .... I don't have the programming skills myself to do this, but if
anyone knows of a tutorial or extension to help, I'd appreciate hearing
about it.

Happy hoolidays folks..

On 24 Dec 2007 in macromedia.dreamweaver, _adrian wrote:

So DW8 already has the behaviors built in to take data from a
recordset, and format it (like date, or numbers) .. but I need it to
be able to take the 10 digits from the particular field, and format
it as a phone number: (xxx) xxx-xxxx .... I don't have the
programming skills myself to do this, but if anyone knows of a
tutorial or extension to help, I'd appreciate hearing about it.

Sorry - missed this in all the holiday hoopla. If you still need it:

<?php if (strlen($row_members['telephone'])>0) { ?>
(<?php echo substr($row_members['telephone'],0,3); ?>) <?php echo substr($row_members['telephone'],3,3); ?>-<?php echo substr($row_members['telephone'],6,4); ?>
<?php }?>

Assumes that the telephone number in the 'telephone' field is a standard
10-digit North American number and uses PHP's substr function to extract
area code, exchange and number. 'telephone' should be of type varchar.
This assumes PHP/MySQL; other models should be similar.

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/contact.php

Hey Joe.. my bad. I should have specified the data is ASP/SQL Server ..
thoughts? Suggestions?

Hey Joe.. my bad. I should have specified the data is ASP/SQL Server ..
thoughts? Suggestions?

On 11 Jan 2008 in macromedia.dreamweaver, _adrian wrote:

Hey Joe.. my bad. I should have specified the data is ASP/SQL Server
.. thoughts? Suggestions?

I don't have time to look it up at the mo', but VBScript should have a
substring function, no? It would work the same, just substitute
VBScript's function. Ah, here - mid():

http://devguru.com/technologies/vbscript/13951.asp

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/contact.php

On 11 Jan 2008 in macromedia.dreamweaver, _adrian wrote:

Hey Joe.. my bad. I should have specified the data is ASP/SQL Server
.. thoughts? Suggestions?

I don't have time to look it up at the mo', but VBScript should have a
substring function, no? It would work the same, just substitute
VBScript's function. Ah, here - mid():

http://devguru.com/technologies/vbscript/13951.asp

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/contact.php

I'll check it out.. thx for the point

I'll check it out.. thx for the point

Hmm.. that looks like it just cuts off by x numbers of characters.. I
actually need to place the parentheses around the phone prefix, and add the
dash between the two other sets of numbers.. all form a single string from
the DB that otherwise looks like this:

2065551212

Hmm.. that looks like it just cuts off by x numbers of characters.. I
actually need to place the parentheses around the phone prefix, and add the
dash between the two other sets of numbers.. all form a single string from
the DB that otherwise looks like this:

2065551212