taggart chesh

Greenhorn
+ Follow
since Mar 25, 2024
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by taggart chesh

Thank you for your reply.
Although I'm a developer in many programming languages, I have never used XSLT to modify XML and I've always used code in the past.
I wanted to use XSLT as it seems to be designed exactly for that purpose but I didn't know where to start.
I just needed a quick fix as I didn't want to study another language for an issue that rarely occurs.
I really appreciate your feedback and I'm sorry you couldn't help me on this occasion.
If I need help on other matters, I will surely post another question.
In case someone else has a similar issue, I managed to get this solution for my problem from another forum which works like a dream.

Hi
I'm new to XSLT and I need to change this xml  to the version below.
I would appreciate help with a suitable XSLT to do the transformation

<?xml version="1.0" encoding="UTF-8" ?>
<FMPDSORESULT xmlns="http://www.filemaker.com/fmpdsoresult">
  <ERRORCODE>0</ERRORCODE>
  <DATABASE>Group First Hub.fmp12</DATABASE>
  <LAYOUT>newslaccounts</LAYOUT>
  <ROW MODID="0" RECORDID="172877">
     <accountref>53-132</accountref>
     <name>Mr Alexall Vant</name>
  </ROW>
  <ROW MODID="0" RECORDID="172878">
     <accountref>50-187</accountref>
     <name>Mr William Alan Alexander</name>
  </ROW>
  <ROW MODID="0" RECORDID="172879">
     <accountref>53-415</accountref>
     <name>Mr Apoltolos</name>
  </ROW>
</FMPDSORESULT>


I need this....

<?xml version="1.0" encoding="UTF-8" ?>
<root>
   <rows>
      <row>
           <accountref>53-132</accountref>
           <name>Mr Alexall Vant</name>
      </row>
      <row>
          <accountref>50-187</accountref>
          <name>Mr William Alan Alexander</name>
      </row>
      <row>
          <accountref>53-415</accountref>
          <name>Mr Apoltolos</name>
      </row>
 </rows>
</root>