asked on

XML TO XML WITH XSLT

I have been receiving one file like this

<?xml version="1.0" encoding="utf-8"?>
<StudentDocument xmlns:sdtc="urn:sl7-org:sdtc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:hvhs="urn:hvhs:student-extensions" xmlns="urn:student-org:v3">
<recordTarget>
<StudentRole>
      <id root="22" extension="65478" />
<id root="23" extension="777-22-333" />
<id root="24" extension="33333333" />
       <addr use="RT">
<streetAddressLine>Address1</streetAddressLine>
<city>City</city>
<state>ST</state>
<postalCode>55555</postalCode>
<country>XT</country>
</addr>
       <telecom use="TE" value="tel:+17248468200" />
      <Student>
<name>
<family>john</family>
              <given>katey</given>
</name>
      </Student>
      </StudentRoleRole>
</recordTarget>
</StudentDocument>

I want to generate formatted XML like the below by using XSLT. How do i write it in visual studio 2013?

<StudentResultData>
      <ROLLNUMBER>777-22-333</ROLLNUMBER>
      <Phone>7248468200</Phone>
      <firstname>John</firstname>
      <lastname>katey</lastname>
      <address1>Address1</address1>
      <city>City<city>
      <zip>55555</zip>
      <state>ST</state>
      <country>XT</country>
</StudentResultData>

zc2

Supposedly you have the XML stored in a file, then go to File menu->New->File, Choose "XSLT File".
Create your XSLT script in the new opened window.
To test the XSLT transformation, go to the XML manu, choose "Start XSLT debugging" or press Alt+F5

mynetquestions

ASKER

I know how to open XSLT file in visual studio 2013. I am looking for XSLT code to generate from the given to required XML format

ASKER CERTIFIED SOLUTION

zc2

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mynetquestions

ASKER

It was really helpful and written my own XSLT files for other XML files based on this solution.