RE: [xsl] Formating numbers

["Michael Kay" <mhk@xxxxxxxxx>]

> 
> I have several cells in my xsl with numbers (from
> a XML), but these numbers aren't formatted

If they aren't formatted at all, you've got problems, but if they follow the
examples below, you can use translate() to convert "," to "." and "." to "":

translate($x, ",.", ".")

You can then use format-number() to produce any output form for the numbers
that you like.

Michael Kay


> 
> For example (because the information
> are transaction banks)
> 
> 1000000 instead of 1.000.000 
> 
> 1687,35 instead of 1.687,35
> 
> Do you know a funtion to "format" the original number into
> a "well-formed" number?
> 
> 
> Thanks
> ------------------------------------------------------------------
> This e-mail and the documents attached are confidential and 
> intended solely
> for the addressee; it may also be privileged. If you receive 
> this e-mail
> in error, please notify the sender immediately and destroy it.
> As its integrity cannot be secured on the Internet, the Atos 
> Origin group
> liability cannot be triggered for the message content. Although the
> sender endeavours to maintain a computer virus-free network, 
> the sender does
> not warrant that this transmission is virus-free and will not 
> be liable for
> any damages resulting from any virus transmitted.
> 
> "Este mensaje y los ficheros adjuntos pueden contener información
> confidencial destinada solamente a la(s) persona(s) mencionadas
> anteriormente. Pueden estar protegidos por secreto 
> profesional Si usted
> recibe este correo electrónico por error, gracias de informar 
> inmediatamente
> al remitente y destruir el mensaje.
> Al no estar asegurada la integridad de este mensaje sobre la red, Atos
> Origin no se hace responsable por su contenido. Su contenido 
> no constituye
> ningún compromiso para el grupo Atos Origin, salvo 
> ratificación escrita por
> ambas partes.
> "Aunque se esfuerza al máximo por mantener su red libre de 
> virus, el emisor
> no puede garantizar nada al respecto y no será responsable de 
> cualesquiera
> daños que puedan resultar de una transmisión de virus"
> ------------------------------------------------------------------
> 
> --+------------------------------------------------------------------
> 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-unsubscribe@xxxxxxxxxxxxxxxxxxxxxx>
> --+--
> 
>