Hi there,
I'm new to this web site and new to xml and xslt.
I have the following document that I would like to transform using xml:
<?xml version="1.0" encoding="iso-8859-1" ?>
- <Report Name="Conway">
- <table1>
- <table1_JobNumber_Collection>
- <table1_JobNumber JobNumber="3401">
- <Detail_Collection>
<Detail ItemNumber="10" ItemSorCode="H0101" ItemSorName="Take up 305mm x 200mm granite kerb, re-square ends as necessary and stack for re-use. Break out 150mm thick concrete foundation and concrete haunch. Load and cart waste to tip." job_item_quantity="2.00" ItemWidth="0.00" ItemLEngth="2.00" ItemDepth="0.00" />
<Detail ItemNumber="10" ItemSorCode="H0101" ItemSorName="Take up 305mm x 200mm granite kerb, re-square ends as necessary and stack for re-use. Break out 150mm thick concrete foundation and concrete haunch. Load and cart waste to tip." job_item_quantity="2.00" ItemWidth="0.00" ItemLEngth="2.00" ItemDepth="0.00" />
<Detail ItemNumber="10" ItemSorCode="H0101" ItemSorName="Take up 305mm x 200mm granite kerb, re-square ends as necessary and stack for re-use. Break out 150mm thick concrete foundation and concrete haunch. Load and cart waste to tip." job_item_quantity="2.00" ItemWidth="0.00" ItemLEngth="2.00" ItemDepth="0.00" />
<Detail ItemNumber="20" ItemSorCode="H0104" ItemSorName="Lay 305mm x 200mm granite kerb to Clause 1109.1AR with 150mm thick, grade C7.5P (ST1) concrete foundation and grade C7.5P (ST1) concrete haunch. Include laying to radius, angled or dropped kerbs with flush or 20mm kerb face." job_item_quantity="2.00" ItemWidth="0.00" ItemLEngth="2.00" ItemDepth="0.00" />
<Detail ItemNumber="20" ItemSorCode="H0104" ItemSorName="Lay 305mm x 200mm granite kerb to Clause 1109.1AR with 150mm thick, grade C7.5P (ST1) concrete foundation and grade C7.5P (ST1) concrete haunch. Include laying to radius, angled or dropped kerbs with flush or 20mm kerb face." job_item_quantity="2.00" ItemWidth="0.00" ItemLEngth="2.00" ItemDepth="0.00" />
<Detail ItemNumber="20" ItemSorCode="H0104" ItemSorName="Lay 305mm x 200mm granite kerb to Clause 1109.1AR with 150mm thick, grade C7.5P (ST1) concrete foundation and grade C7.5P (ST1) concrete haunch. Include laying to radius, angled or dropped kerbs with flush or 20mm kerb face." job_item_quantity="2.00" ItemWidth="0.00" ItemLEngth="2.00" ItemDepth="0.00" />
</Detail_Collection>
</table1_JobNumber>
I would like the resulting document to look like this
<JobFile>
<JobDetails>
<JobNumber>90903</JobNumber>
<ItemDetails>
<ItemNumber>10</ItemNumber>
<ItemSorCode>CY00478</ItemSorCode>
<ItemSorName>Provide necessary resources to site, in order to carry out welding and metal work repairs to fire barriers.</ItemSorName>
<ItemQuantity>1.00</ItemQuantity>
<ItemWidth>0</ItemWidth>
<ItemLength>0</ItemLength>
<ItemDepth>0</ItemDepth>
</ItemDetails>
</JobDetails>
</JobFile>
where <table1_JobNumber JobNumber> = <JobNumber>
<Detail_Collection> = <ItemDetails>
<Detail
ItemNumber = ItemNumber
ItemSorCode = ItemSorCode
ItemSorName = ItemSorName
job_item_quantity = ItemQuantity
ItemWidth = ItemWidth
ItemLEngth = ItemLength
ItemDepth = ItemDepth >