XML transformation with filters .. help!

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
Hi!
I need your help to achieve the result I want...
This is my XML:
<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <<span style="color:#A31515; FileIndex<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Year <span style="color:Red; id<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 2010<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ShiftsRota <span style="color:Red; weekNumber<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 44<span style="color:Black; " <span style="color:Red; startDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 18/10/10<span style="color:Black; " <span style="color:Red; endDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 22/10/10<span style="color:Black; " <span style="color:Red; type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Official<span style="color:Black; " <span style="color:Red; src<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Tabelle_Turni/CCG_10_18.pdf<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; ShiftsRota <span style="color:Red; weekNumber<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 41<span style="color:Black; " <span style="color:Red; startDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 18/10/10<span style="color:Black; " <span style="color:Red; endDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 22/10/10<span style="color:Black; " <span style="color:Red; type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Official<span style="color:Black; " <span style="color:Red; src<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Tabelle_Turni/CCG_10_18.pdf<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; ShiftsRota <span style="color:Red; weekNumber<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 42<span style="color:Black; " <span style="color:Red; startDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 18/10/10<span style="color:Black; " <span style="color:Red; endDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 22/10/10<span style="color:Black; " <span style="color:Red; type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Official<span style="color:Black; " <span style="color:Red; src<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Tabelle_Turni/CCG_10_18.pdf<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; ShiftsRota <span style="color:Red; weekNumber<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 43<span style="color:Black; " <span style="color:Red; startDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 18/10/10<span style="color:Black; " <span style="color:Red; endDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 22/10/10<span style="color:Black; " <span style="color:Red; type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Official<span style="color:Black; " <span style="color:Red; src<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Tabelle_Turni/CCG_10_18.pdf<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; ShiftsRota <span style="color:Red; weekNumber<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 44<span style="color:Black; " <span style="color:Red; startDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 25/10/10<span style="color:Black; " <span style="color:Red; endDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 29/10/10<span style="color:Black; " <span style="color:Red; type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Temporary<span style="color:Black; " <span style="color:Red; src<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Tabelle_Turni/[T. 44-2010]_CCG_25 ottobre.pdf<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; ShiftsRota <span style="color:Red; weekNumber<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 45<span style="color:Black; " <span style="color:Red; startDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 01/11/10<span style="color:Black; " <span style="color:Red; endDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 06/11/10<span style="color:Black; " <span style="color:Red; type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Temporary<span style="color:Black; " <span style="color:Red; src<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Tabelle_Turni/[T. 45-2010]_CCG_01 novembre.pdf<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; ShiftsRota <span style="color:Red; weekNumber<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 47<span style="color:Black; " <span style="color:Red; startDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 15/11/10<span style="color:Black; " <span style="color:Red; endDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 20/11/10<span style="color:Black; " <span style="color:Red; type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Temporary<span style="color:Black; " <span style="color:Red; src<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Tabelle_Turni/[T. 47-2010]_CCG_15 novembre.pdf<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; </<span style="color:#A31515; Year<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Year <span style="color:Red; id<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 2011<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ShiftsRota <span style="color:Red; weekNumber<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 4<span style="color:Black; " <span style="color:Red; startDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 17/01/11<span style="color:Black; " <span style="color:Red; endDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 22/01/11<span style="color:Black; " <span style="color:Red; type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Temporary<span style="color:Black; " <span style="color:Red; src<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Tabelle_Turni/[T.4-2011]_CCG_17 gennaio.pdf<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; ShiftsRota <span style="color:Red; weekNumber<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 7<span style="color:Black; " <span style="color:Red; startDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 07/02/11<span style="color:Black; " <span style="color:Red; endDate<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 12/02/11<span style="color:Black; " <span style="color:Red; type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Temporary<span style="color:Black; " <span style="color:Red; src<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Tabelle_Turni/[T.7-2011]_CCG_07 febbraio.pdf<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; </<span style="color:#A31515; Year<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; FileIndex<span style="color:Blue; >
[/code]
I need to extract, ordered, the last two or three item of the current year where type="Temporary" and the same for type="Official".
I wrote some xsl before.. but actually Im a little bit "out of training" and Im actuaslly not able to get the right result! :D
Can you help me?

P.S. sorry for my poor english.. I hope you understand! :)

View the full article
 
Back
Top