i have a set of xml data from a database, i want to transform these data into a form that would conform to the target data. in the sense that the elements node would change and the text nodes will also be rearranged something like

source

<?xml version="1.0" encoding="UTF-8"?>
<XMLCreators>
<row>
<RateNumber>1</RateNumber>
<RateLetter>Null</RateLetter>
<AssessmentStreet>Abesinia Passage</AssessmentStreet>
<RateAccomDesc>Dwelling (Part Of)</RateAccomDesc>
</row>
</XMLCreators>

to
target

<?xml version="1.0" encoding="UTF-8"?>
<XMLCreators>
<row>
<locatorDesignator>dwelling (part of) </locatorDesignator>
<locatorName>Null</locatorName>
<locator>1</locator>
<thoroughfare>Abesinia Passage</thoroughfare>
<addressArea>Null</addressArea>
</row>
<XMLCreators>

pls if u could help in anyway or direct me to any tutorials on how to do this. thank you

Linked to and responded here

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.