XML to XML Using XSLT

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Alexis (is4fun2k_at_yahoo.com)
Date: 09/15/04 

Date: 15 Sep 2004 16:05:02 -0700

Hi,
I need to transform one xml document into a second xml document. They
both have many nodes so xslt works fine, but there is one node I have
not figure out how to transform.

Here it is:
Node in Input File.

<FullAddress>JOHN SMITH@19495 BISCAYNE
BLVD@MIAMI@FL/33180@USA</FullAddress>

The Result should be:

<Name>JOHN SMITH</Name>
<Address>19495 BISCAYNE BLVD</Address>
<City>MIAMI</City>
<State>FL</State>
<ZipCode>33180</ZipCode>
<Country>USA</Country>

It seems to me I have to "Split" or "Parse" the FullAddress node by
the "@" character, but HOW I do that in XSLT?

Note: The Name element is optional in the FullAdress node. So this
input node is also valid.

<FullAddress>19495 BISCAYNE BLVD@MIAMI@FL/33180@USA</FullAddress>

Any Ideas?
Thanks

Relevant Pages

  • XML to XML Using XSLT
    ... I need to transform one xml document into a second xml document. ... 19495 BISCAYNE BLVD ... but HOW I do that in XSLT? ...
    (microsoft.public.dotnet.xml)
  • Re: Need to generate a text file.
    ... XSLT is used to transform an XML document into another XML document, ... Normally XSLT does this by transforming each XML element into an ...
    (microsoft.public.dotnet.languages.csharp)
  • Transform using xml and xsd
    ... I am doing a transform using an xml document and an xslt based on the ... transform know it is based on a schema rather than an instance. ...
    (microsoft.public.dotnet.xml)
  • help with XSLT
    ... Hi to all I need to transform an xml document from a format to another. ... In my source XML I have a tag value that is a list of codes. ... How do i do that with XSLT? ...
    (comp.text.xml)
  • Re: XML Transform
    ... I dont pass the XSLT as a parameter to the C# beacause they are store in the ... same database. ... I have a table that has the XSLT and the information level (we ... we have 3 XSLT that we apply to the XML Document received). ...
    (microsoft.public.sqlserver.xml)