Phone Number Format

[Dino Chiesa [MSFT]]

Ken,

your regex has to be mapped to the INPUT, not the output. by including
parens and dashes in the regex, you are guaranteeing that the normalized
version of the number ("1234567890") will not be matched.

regex string:
(\d\d\d)(\d\d\d)(\d\d\d\d)

replacement string
($1) $2-$3

applied to this input:
1234567890

generates:
(123) 456-7890


also, a tip for you, and all other regex hackers: get this tool:
[url]http://www.organicbit.com/regex[/url]

Free, small, easy, useful.

-Dino

"Ken" <k_schallmo@hotmail.com> wrote in message
news:OD9wzgfVDHA.2344@TK2MSFTNGP09.phx.gbl...

> How do apply a phone number format to a string? I have the regular
> expression, but have been unable to figure out how to apply the expression
> to a string from a database. I am not trying to validate the data, but
> display the output from the database in a nice format.
> Phone number string = 1234567890
> Regular expression = ((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}
> Desired output = (123) 456-7890
>
> Thank you,
> Ken
>
>

[Chris Jackson]

From MSDN:

Double myDouble = 1234567890;
String myString = myDouble.ToString( "(###) ### - ####" );
// The value of myString is "(123) 456 - 7890".


--
Chris Jackson
Software Engineer
Microsoft MVP - Windows XP
Windows XP Associate Expert
--
"Ken" <k_schallmo@hotmail.com> wrote in message
news:OD9wzgfVDHA.2344@TK2MSFTNGP09.phx.gbl...

> How do apply a phone number format to a string? I have the regular
> expression, but have been unable to figure out how to apply the expression
> to a string from a database. I am not trying to validate the data, but
> display the output from the database in a nice format.
> Phone number string = 1234567890
> Regular expression = ((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}
> Desired output = (123) 456-7890
>
> Thank you,
> Ken
>
>

[Shahram Khosraviani]

hi ken

this will work ..
Response.Write(Format(Convert.ToDouble(txtPhone.Te xt), "(###) ###-####"))

Hope it helps
Shahram


"Ken" <k_schallmo@hotmail.com> wrote in message
news:OD9wzgfVDHA.2344@TK2MSFTNGP09.phx.gbl...

> How do apply a phone number format to a string? I have the regular
> expression, but have been unable to figure out how to apply the expression
> to a string from a database. I am not trying to validate the data, but
> display the output from the database in a nice format.
> Phone number string = 1234567890
> Regular expression = ((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}
> Desired output = (123) 456-7890
>
> Thank you,
> Ken
>
>

[Eddy Soeparmin]

Hi Dino,

I tried that code, but it didn't work. Here is some code snippet of mine.
Please correct me. Thanks.

<Columns>
<asp:HyperLinkColumn Text="Smoking History"
DataNavigateUrlField="legal_entity_sk"
DataNavigateUrlFormatString="SmokingHistoryList.as px?legal_entity_sk={0}"
DataTextField="legal_entity_sk" HeaderText="Smoking
History"></asp:HyperLinkColumn>
<asp:BoundColumn DataField="cf_FullName"
HeaderText="Name"></asp:BoundColumn>
<asp:BoundColumn DataField="user_id" HeaderText="User
ID"></asp:BoundColumn>
<asp:BoundColumn DataField="cf_CompanyName"
HeaderText="Company"></asp:BoundColumn>
<asp:BoundColumn DataField="e_mail_work" HeaderText="Email
(Work)"></asp:BoundColumn>
<asp:BoundColumn DataField="e_mail_home" HeaderText="Email
(Home)"></asp:BoundColumn>
<asp:BoundColumn DataField="phone_business" HeaderText="Phone (Work)"
DataFormatString="(\d\d\d)(\d\d\d)(\d\d\d\d)"></asp:BoundColumn>
<asp:BoundColumn DataField="phone_home" HeaderText="Phone
(Home)"></asp:BoundColumn>
</Columns>

Eddy

"Dino Chiesa [MSFT]" <dinoch@microsoft.com> wrote in message
news:unrjBrfVDHA.208@tk2msftngp13.phx.gbl...

> Ken,
>
> your regex has to be mapped to the INPUT, not the output. by including
> parens and dashes in the regex, you are guaranteeing that the normalized
> version of the number ("1234567890") will not be matched.
>
> regex string:
> (\d\d\d)(\d\d\d)(\d\d\d\d)
>
> replacement string
> ($1) $2-$3
>
> applied to this input:
> 1234567890
>
> generates:
> (123) 456-7890
>
>
> also, a tip for you, and all other regex hackers: get this tool:
> [url]http://www.organicbit.com/regex[/url]
>
> Free, small, easy, useful.
>
> -Dino
>
> "Ken" <k_schallmo@hotmail.com> wrote in message
> news:OD9wzgfVDHA.2344@TK2MSFTNGP09.phx.gbl...

> > How do apply a phone number format to a string? I have the regular
> > expression, but have been unable to figure out how to apply the

expression

> > to a string from a database. I am not trying to validate the data, but
> > display the output from the database in a nice format.
> > Phone number string = 1234567890
> > Regular expression = ((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}
> > Desired output = (123) 456-7890
> >
> > Thank you,
> > Ken
> >
> >

>
>