Format Phone number

[Anil Kumar Veeramalli]

Hi,

I want to format phone number xxx-xxx-xxxx format.

I am using XSL1.0
I tried with below approaches but didn't work

1) <xsl:decimal-format name="staff" digit="D" />
<xsl:value-of select='format-number(123456789, "DDD-DDD-DDDD", "staff")' />
2) <xsl:value-of select='format-number(123456789, "###-###-####")' />

what is the correct approach to format the number.

Thanks,
Anil


--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Michael Müller-Hillebrand]

In the first place, I don't think that a phone number is numeric, but anyway:

<xsl:decimal-format name="phonenumber" decimal-separator="-" grouping-separator="&#x2011;"/>

<xsl:template match="/">
<xsl:value-of select='format-number(123456789 div 10000, "#&#x2011;###-####", "phonenumber")' />
</xsl:template>

gives me: 12‑345-6789

Because the decimal separator and the grouping separator are not allowed to be the same character I chose the non-breaking hyphen &#x2011; as an alternative to make the above example work.

- Michael Müller-Hillebrand

Am 21.12.2009 um 08:20 schrieb Anil Kumar Veeramalli:

> Hi,
>
> I want to format phone number xxx-xxx-xxxx format.
>
> I am using XSL1.0
> I tried with below approaches but didn't work
>
> 1) <xsl:decimal-format name="staff" digit="D" />
> <xsl:value-of select='format-number(123456789, "DDD-DDD-DDDD", "staff")' />
> 2) <xsl:value-of select='format-number(123456789, "###-###-####")' />
>
> what is the correct approach to format the number.
>
> Thanks,
> Anil

--
_______________________________________________________________
Michael Müller-Hillebrand: Dokumentations-Technologie
Adobe Certified Expert, FrameMaker
Lösungen und Training, FrameScript, XML/XSL, Unicode
Blog: http://cap-studio.de/ - Tel. [phone]






--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Wolfgang Laun]

You should use this declaration:
<xsl:decimal-format name="staff" grouping-separator="-"/>

and then, e.g.,
<xsl:value-of select='format-number( 0112223333, "000-000-0000", "staff")'/>

This also handles a leading zero, which may or may not be necessary in
your case.
-W

On Mon, Dec 21, 2009 at 8:20 AM, Anil Kumar Veeramalli
<***@frescoinformatics.com> wrote:
>
> Hi,
>
> I want to format phone number xxx-xxx-xxxx format.
>
> I am using XSL1.0
> I tried with below approaches but didn't work
>
> 1) <xsl:decimal-format name="staff" digit="D" />
> <xsl:value-of select='format-number(123456789, "DDD-DDD-DDDD", "staff")' />
> 2) <xsl:value-of select='format-number(123456789, "###-###-####")' />
>
> what  is the correct approach to format the number.
>
> Thanks,
> Anil
>
>
> --~------------------------------------------------------------------
> XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
> --~--
>

--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Anil Kumar Veeramalli]

thanks for your response. this is returing me xx-xxxx-xxxx format not
xxx-xxx-xxxx.

what could be the issue.
Thanks,
Anil


Wolfgang Laun wrote:
> You should use this declaration:
> <xsl:decimal-format name="staff" grouping-separator="-"/>
>
> and then, e.g.,
> <xsl:value-of select='format-number( 0112223333, "000-000-0000", "staff")'/>
>
> This also handles a leading zero, which may or may not be necessary in
> your case.
> -W
>
> On Mon, Dec 21, 2009 at 8:20 AM, Anil Kumar Veeramalli
> <***@frescoinformatics.com> wrote:
>
>> Hi,
>>
>> I want to format phone number xxx-xxx-xxxx format.
>>
>> I am using XSL1.0
>> I tried with below approaches but didn't work
>>
>> 1) <xsl:decimal-format name="staff" digit="D" />
>> <xsl:value-of select='format-number(123456789, "DDD-DDD-DDDD", "staff")' />
>> 2) <xsl:value-of select='format-number(123456789, "###-###-####")' />
>>
>> what is the correct approach to format the number.
>>
>> Thanks,
>> Anil
>>
>>
>> --~------------------------------------------------------------------
>> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
>> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
>> or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
>> --~--
>>
>>
>
> --~------------------------------------------------------------------
> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
> --~--
>
>
>



--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Michael Kay]

>
> thanks for your response. this is returing me xx-xxxx-xxxx
> format not xxx-xxx-xxxx.
>
> what could be the issue.

That looks like a bug in your XSLT processor.

(But this is not the way I would recommend tackling this problem).

Regards,

Michael Kay
http://www.saxonica.com/
http://twitter.com/michaelhkay


--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Anil Kumar Veeramalli]

yes there is a issue with even this approach.
I am using XSL 1.0
1.

<xsl:decimal-format name="phonenumber" decimal-separator="-" grouping-separator="&#x2011;"/>
<xsl:template match="/">
<xsl:value-of select='format-number(1234567890 div 10000, "#&#x2011;###-####", "phonenumber")' />
</xsl:template>


its returning 123-456-789 which is wrong. (Zero is missing)

2.
<xsl:decimal-format name="staff" grouping-separator="-"/>

<xsl:value-of select='format-number(9058957869, "000-000-0000",
"staff")'/>

its returning me 90-5895-7869 which is wrong.

required out put is 905-895-7869

Please suggest me the correct approach.

Thanks,
Anil
Michael Kay wrote:

>> thanks for your response. this is returing me xx-xxxx-xxxx
>> format not xxx-xxx-xxxx.
>>
>> what could be the issue.
>>
>
> That looks like a bug in your XSLT processor.
>
> (But this is not the way I would recommend tackling this problem).
>
> Regards,
>
> Michael Kay
> http://www.saxonica.com/
> http://twitter.com/michaelhkay
>
>
> --~------------------------------------------------------------------
> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
> --~--
>
>
>



--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Kerry, Richard]

This is all very well but phone numbers aren't formatted like that - they're #####-######, or ###-####-####
And of course they all start with a '0' so can't be handled as numbers. And they're all eleven digits, not ten.

And of course if they're international they don't have the zero but start with + (ie +##-####-######), sometimes given as +(0)##-####-###### to indicate both international and national. And some people actually put 00 as that's the real code for +. So that may add three digits.

And actually are usually given with spaces (ie "##### ######", or "### #### ####", or "+## #### ######", or "+(0)##-####-######".

Though of course 'national' in my context means UK. ;-)

Which brings us back to Michael's earlier recommendation that you don't hard-code any particular national convention regarding how phone numbers should be formatted.


Helpfully,
Maybe,
Richard.




> -----Original Message-----
> From: Anil Kumar Veeramalli [mailto:***@frescoinformatics.com]
> Sent: 21 December 2009 11:20
> To: xsl-***@lists.mulberrytech.com
> Subject: Re: [xsl] Format Phone number
>
> yes there is a issue with even this approach.
> I am using XSL 1.0
> 1.
>
> <xsl:decimal-format name="phonenumber" decimal-separator="-"
> grouping-separator="&#x2011;"/>
> <xsl:template match="/">
> <xsl:value-of select='format-number(1234567890 div 10000,
> "#&#x2011;###-####", "phonenumber")' />
> </xsl:template>
>
>
> its returning 123-456-789 which is wrong. (Zero is missing)
>
> 2.
> <xsl:decimal-format name="staff" grouping-separator="-"/>
>
> <xsl:value-of select='format-number(9058957869, "000-000-0000",
> "staff")'/>
>
> its returning me 90-5895-7869 which is wrong.
>
> required out put is 905-895-7869
>
> Please suggest me the correct approach.
>
> Thanks,
> Anil
> Michael Kay wrote:
>
> >> thanks for your response. this is returing me xx-xxxx-xxxx
> >> format not xxx-xxx-xxxx.
> >>
> >> what could be the issue.
> >>
> >
> > That looks like a bug in your XSLT processor.
> >
> > (But this is not the way I would recommend tackling this problem).
> >
> > Regards,
> >
> > Michael Kay
> > http://www.saxonica.com/
> > http://twitter.com/michaelhkay
> >

--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Michael Kay]

There is actually a difference between XSLT 1.0 and XSLT 2.0 here.

In XSLT 1.0, the specification of the picture format for format-number was
based on the specification of class DecimalFormat in Java JDK 1.1, which can
be found here:

http://sunsite.dcc.uchile.cl/java/docs/jdk1.1.8/docs/api/java.text.DecimalFo
rmat.html

It states:

The grouping separator is commonly used for thousands, but in some countries
for ten-thousands. The interval is a constant number of digits between the
grouping characters, such as 100,000,000 or 1,0000,0000. If you supply a
pattern with multiple grouping characters, the interval between the last one
and the end of the integer is the one that is used.

In XSLT 2.0, the specification is no longer based on the JDK, and the
interval between grouping separators is variable.

I would not recommend using format-number() for formatting phone numbers.
Use concat(substring(X, 1, 3), '-', substring(X, 4, 3), '-', ....).

Regards,

Michael Kay
http://www.saxonica.com/
http://twitter.com/michaelhkay



> -----Original Message-----
> From: Anil Kumar Veeramalli [mailto:***@frescoinformatics.com]
> Sent: 21 December 2009 11:20
> To: xsl-***@lists.mulberrytech.com
> Subject: Re: [xsl] Format Phone number
>
> yes there is a issue with even this approach.
> I am using XSL 1.0
> 1.
>
> <xsl:decimal-format name="phonenumber" decimal-separator="-"
> grouping-separator="&#x2011;"/> <xsl:template match="/">
> <xsl:value-of select='format-number(1234567890 div 10000,
> "#&#x2011;###-####", "phonenumber")' /> </xsl:template>
>
>
> its returning 123-456-789 which is wrong. (Zero is missing)
>
> 2.
> <xsl:decimal-format name="staff" grouping-separator="-"/>
>
> <xsl:value-of select='format-number(9058957869,
> "000-000-0000", "staff")'/>
>
> its returning me 90-5895-7869 which is wrong.
>
> required out put is 905-895-7869
>
> Please suggest me the correct approach.
>
> Thanks,
> Anil
> Michael Kay wrote:
>
> >> thanks for your response. this is returing me xx-xxxx-xxxx format
> >> not xxx-xxx-xxxx.
> >>
> >> what could be the issue.
> >>
> >
> > That looks like a bug in your XSLT processor.
> >
> > (But this is not the way I would recommend tackling this problem).
> >
> > Regards,
> >
> > Michael Kay
> > http://www.saxonica.com/
> > http://twitter.com/michaelhkay
> >
> >
> >
> --~------------------------------------------------------------------
> > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
> > To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> > or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
> > --~--
> >
> >
> >
>
>
>
> --~------------------------------------------------------------------
> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
> --~--
>


--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[B Tommie Usdin]

>Which brings us back to Michael's earlier recommendation that you
>don't hard-code any particular national convention regarding how
>phone numbers should be formatted.

Actually, I think it is as unhelpful to insist that all users treat
all applications as if they were in use world wide as to insist that
all users use a local convention. For example, while I applaud XML's
accommodation of names in virtually all languages that doesn't mean
that an application written for my neighborhood association needs to
accommodate street names in Japanese - we don't have any and we know
we won't have any.

Based on the information we have seen from this user, a local
convention for formatting phone numbers may well meet the need.
Reminding a user that everyone doesn't have the same requirements
seems to me to be helpful. Insisting that the user accommodate those
others without knowing the scope of application is ... well ... as
narrow minded as we are telling the user s/he is. And perhaps less
well informed.

-- Tommie
--

======================================================================
B. Tommie Usdin mailto:***@mulberrytech.com
Mulberry Technologies, Inc. http://www.mulberrytech.com
17 West Jefferson Street Phone: [phone]
Suite 207 Direct Line: 301/315-9634
Rockville, MD 20850 Fax: [phone]
----------------------------------------------------------------------
Mulberry Technologies: A Consultancy Specializing in XML and SGML
======================================================================

--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Wolfgang Laun]

The javadoc for java.text.DecimalFormat which is explicitly referred
to by the XSLT 1.0 spec contains this paragraph - note the last
sentence:

<quote>
The grouping separator is commonly used for thousands, but in some
countries it separates ten-thousands. The grouping size is a constant
number of digits between the grouping characters, such as 3 for
100,000,000 or 4 for 1,0000,0000. If you supply a pattern with
multiple grouping characters, the interval between the last one and
the end of the integer is the one that is used. So "#,##,###,####" ==
"######,####" == "##,####,####".
</quote>

XSLT 2.0 defines format-number without such a reference, which
explains the difference.

I'd prefer substring and concatenation functions for creating the
999-999-9999 pattern.
-W


On Mon, Dec 21, 2009 at 11:36 AM, Michael Kay <***@saxonica.com> wrote:
>
> >
> > thanks for your response. this is returing me  xx-xxxx-xxxx
> > format not xxx-xxx-xxxx.
> >
> > what could be the issue.
>
> That looks like a bug in your XSLT processor.
>
> (But this is not the way I would recommend tackling this problem).
>
> Regards,
>
> Michael Kay
> http://www.saxonica.com/
> http://twitter.com/michaelhkay
>
>
> --~------------------------------------------------------------------
> XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
> --~--
>

--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Anil Kumar Veeramalli]

Hi Michael,
I finally got it working with this.

<xsl:decimal-format name="phonenumber" decimal-separator="-"
grouping-separator="&#x2011;"/>
<xsl:variable name="poval1" select='format-number(1234567890 div
10000,"0&#x2011;000-0000", "phonenumber")'/>

do you think is this good approach?


Thanks,
Anil

Michael Kay wrote:
>> thanks for your response. this is returing me xx-xxxx-xxxx
>> format not xxx-xxx-xxxx.
>>
>> what could be the issue.
>>
>
> That looks like a bug in your XSLT processor.
>
> (But this is not the way I would recommend tackling this problem).
>
> Regards,
>
> Michael Kay
> http://www.saxonica.com/
> http://twitter.com/michaelhkay
>
>
> --~------------------------------------------------------------------
> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
> --~--
>
>
>



--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Michael Müller-Hillebrand]

Am 21.12.2009 um 12:33 schrieb Anil Kumar Veeramalli:

> do you think is this good approach?

No. It seems to fulfill a short-term request but it is going to fail soon. Because as soon as any extra requirement appears (and they usually do), you are stuck. Whether it is the leading "+", additional digits in parentheses, a different international digit grouping, or the separation of country/city/local parts of the number. Especially the latter would be fun, because you would have to calculate the full-form "number" from individual parts... in Germany we have city code with 3…6 digits plus local "numbers" ranging from 3…8 digits. Hey, and what about vanity numbers...

Try a more solid approach. Even though we call it a telephone "number" it is not a numeric, like every computer likes to treat it.

Good luck,

- Michael Müller-Hillebrand

--
_______________________________________________________________
Michael Müller-Hillebrand: Dokumentations-Technologie
Adobe Certified Expert, FrameMaker
Lösungen und Training, FrameScript, XML/XSL, Unicode
Blog: http://cap-studio.de/ - Tel. [phone]






--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Michael Kay]

>
> I want to format phone number xxx-xxx-xxxx format.

Are you really sure it is wise to write an application that can only handle
phone numbers in US format? This kind of thing gets very annoying for users
in other countries. (I've had to give an invented phone number before now to
get past the "validation" on the input form...)

A phone number should not really be treated as a number: leading zeroes are
significant, and arithmetic operations are meaningless. It's really just a
string whose component characters happen to be digits.
>
> I am using XSL1.0
> I tried with below approaches but didn't work

Please don't say that something "didn't work" without telling us the
symptoms. Did it produce output, or an error message? If it produced output,
what was the output and how was it wrong? If it produced an error message,
what was the message?

Regards,

Michael Kay
http://www.saxonica.com/
http://twitter.com/michaelhkay


--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Owen Rees]

--On Monday, December 21, 2009 10:27:50 +0000 Michael Kay
<***@saxonica.com> wrote:

> A phone number should not really be treated as a number: leading zeroes
> are significant, and arithmetic operations are meaningless. It's really
> just a string whose component characters happen to be digits.

The first character of a phone number can be a '+'. Unlike a conventional
numeric context, omitting the '+' if it should be there or adding it if it
should not makes a big difference.




--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Gannon Dick]

>Which brings us back to Michael's earlier recommendation that you
>don't hard-code any particular national convention regarding how
>phone numbers should be formatted.

Actually, I think it is as unhelpful to insist that all users treat
all applications as if they were in use world wide as to insist that
all users use a local convention.

---------------------------------------

For users Tommie is right, for good programming practice Dr. Kay has a point. There is a Regular Expression that will validate any North American phone number given in the Perl Cookbook. For a user that might be the end of the discussion. However, a programmer can still commit a meta data error in a web form by requiring both requiring the field content AND validation. An "out of area" bypass checkbox would enable field content OR validation.

Not blaming the user involves some commercial risk, but not a logical dilemma.

"It is difficult to get a man to understand something when his livelihood depends on him not understanding it." --Upton Sinclair








--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--

[Wendell Piez]

Hi,

At 05:40 PM 12/22/2009, was written:
> >Which brings us back to Michael's earlier recommendation that you
> >don't hard-code any particular national convention regarding how
> >phone numbers should be formatted.
>
>Actually, I think it is as unhelpful to insist that all users treat
>all applications as if they were in use world wide as to insist that
>all users use a local convention.
>
>---------------------------------------
>
>For users Tommie is right, for good programming practice Dr. Kay has
>a point. There is a Regular Expression that will validate any North
>American phone number given in the Perl Cookbook. For a user that
>might be the end of the discussion. However, a programmer can still
>commit a meta data error in a web form by requiring both requiring
>the field content AND validation. An "out of area" bypass checkbox
>would enable field content OR validation.
>
>Not blaming the user involves some commercial risk, but not a logical dilemma.

Mm, indeed, but the OP asked not how to validate phone numbers but
how to format them in XSLT. If he had only said "US phone numbers"
(or "numbers according to the North American Numbering Plan") in his
query, this entire discussion would have been moot (in the American sense).

So, according to one view at least, the problem arises due not to
inadequate analysis but simply inadequate specification -- an easy
and common mistake and perhaps not in itself terribly blameworthy.
Who are we to know?

Cheers,
Wendell


======================================================================
Wendell Piez mailto:***@mulberrytech.com
Mulberry Technologies, Inc. http://www.mulberrytech.com
17 West Jefferson Street Direct Phone: [phone]
Suite 207 Phone: [phone]
Rockville, MD 20850 Fax: [phone]
----------------------------------------------------------------------
Mulberry Technologies: A Consultancy Specializing in SGML and XML
======================================================================


--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-***@lists.mulberrytech.com>
--~--