Altova Mailing List Archives>Archive Index >microsoft.public.xsl Archive Home >Recent entries >Thread Prev - Re: Converting a xml STRING column displaying a long date, to dd/mm/yy >Thread Next - Re: Converting a xml STRING displaying a long date, to dd/mm/yyyy Re: Converting a xml STRING displaying a long date, to dd/mm/yyyyTo: NULL Date: 12/14/2008 2:24:00 PM Thanks for the response Joe. How do I figure out the XSLT version? I use .NET3.5 with VS2008. I read your recommendations, but I was hoping for a real XSLT example for my case. As I mentioned , I'm a begginer in XML/XSLT and the things I've done with them, are far beyond my expectations for now. Also, time is running out for my project (as always happens!) and a XSLT research/training is out of the question. Sure later, I'll start delving in more depth. I really liked the other option, about VB.NET. How could I call a VB.NET function that does the transformation and inject a "14/12/2008" string, in my CSV result along with the other column data? Following, is an excerpt of my XML file. <?xml version="1.0" encoding="utf-8"?> <Coupon type="FOOTBALL"> <Event code="200"> <Status>ACTIVE</Status> <League>GE2</League> <Date>Monday 22 December 2008</Date> <Time>19:00</Time> <Code>200 </Code> <Apodosi1>1,80</Apodosi1> <HomeTeamAdvantage /> <HomeTeam>KOBLENTZ</HomeTeam> <ApodosiX>3,15</ApodosiX> <AwayTeam>INGOLDSTAD</AwayTeam> <AwayTeamAdvantage /> <Apodosi2>3,50</Apodosi2> <Apodosi1X>1,15</Apodosi1X> <Apodosi12>1,19</Apodosi12> <ApodosiX2>1,66</ApodosiX2> <ApodosiHalf1>2,30</ApodosiHalf1> <ApodosiHalfX>1,90</ApodosiHalfX> <ApodosiHalf2>3,75</ApodosiHalf2> <ApodosiUNDER>1,75</ApodosiUNDER> <ApodosiOVER>1,70</ApodosiOVER> <ApodosiSOG01>3,20</ApodosiSOG01> <ApodosiSOG23>1,80</ApodosiSOG23> <ApodosiSOG46>3,00</ApodosiSOG46> <ApodosiSOG7>15,00</ApodosiSOG7> </Event> <Event code="201"> <Status>COMPLETE</Status> <League>EN2</League> <Date>Friday 12 December 2008</Date> <Time>19:00</Time> <Code>200 </Code> <Apodosi1>1,85</Apodosi1> <HomeTeamAdvantage /> <HomeTeam>WATFORD</HomeTeam> <ApodosiX>3,15</ApodosiX> <AwayTeam>COVENTRY</AwayTeam> <AwayTeamAdvantage /> <Apodosi2>3,50</Apodosi2> <Apodosi1X>1,15</Apodosi1X> <Apodosi12>2,19</Apodosi12> <ApodosiX2>1,66</ApodosiX2> <ApodosiHalf1>2,30</ApodosiHalf1> <ApodosiHalfX>3,90</ApodosiHalfX> <ApodosiHalf2>3,75</ApodosiHalf2> <ApodosiUNDER>1,65</ApodosiUNDER> <ApodosiOVER>1,70</ApodosiOVER> <ApodosiSOG01>3,20</ApodosiSOG01> <ApodosiSOG23>2,80</ApodosiSOG23> <ApodosiSOG46>4,00</ApodosiSOG46> <ApodosiSOG7>18,00</ApodosiSOG7> </Event> <Event code="202"> <Status>ACTIVE</Status> <League>EN1</League> <Date>Saturday 27 December 2008</Date> <Time>19:00</Time> <Code>200 </Code> <Apodosi1>1,85</Apodosi1> <HomeTeamAdvantage /> <HomeTeam>ARSENAL</HomeTeam> <ApodosiX>3,15</ApodosiX> <AwayTeam>CARDIFF</AwayTeam> <AwayTeamAdvantage /> <Apodosi2>3,50</Apodosi2> <Apodosi1X>1,15</Apodosi1X> <Apodosi12>2,19</Apodosi12> <ApodosiX2>1,66</ApodosiX2> <ApodosiHalf1>2,30</ApodosiHalf1> <ApodosiHalfX>3,90</ApodosiHalfX> <ApodosiHalf2>3,75</ApodosiHalf2> <ApodosiUNDER>1,65</ApodosiUNDER> <ApodosiOVER>1,70</ApodosiOVER> <ApodosiSOG01>3,20</ApodosiSOG01> <ApodosiSOG23>2,80</ApodosiSOG23> <ApodosiSOG46>4,00</ApodosiSOG46> <ApodosiSOG7>18,00</ApodosiSOG7> </Event> </Coupon> | ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
