Hi there, I am new to XSLT but saw your post and decided to attempt a solution, mainly as an exercise for myself.
The responses you have received have better solutions than this one, but I offer a novice's solution, which is neither elegant or flexible (sorry for the formatting) <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; version="2.0"> <xsl:output indent="yes"/> <!-- file location--> <xsl:variable name="in" select="unparsed-text('file:///c:/sean/xsl/commadelimited/comma_delimite d.txt')"/> <xsl:template name="initial" match="/"> <xsl:element name="values"> <!-- Iterate through the lines in the file --> <xsl:for-each select="tokenize($in,'\r\n')"> <xsl:variable name="line" select="."/> <!-- Analyze the entire line and break into captured groups (by using ( ) around the individual pieces --> <xsl:analyze-string select="$line" regex="([0-9]+),\s*([0-9]+),\s*([A-Z]+),\s*([0-9]+),\s*([A-Z]+),\s*([A-Z ])+,s*([A-Z]+),\s*([A-Z]+)"> <xsl:matching-substring> <xsl:element name="line"> <!-- This just puts out the line, was included for testing purposed <xsl:element name="RawData"> <xsl:value-of select="regex-group(0)"/> </xsl:element> --> <xsl:element name="Column1"> <xsl:value-of select="regex-group(1)"/> </xsl:element> <xsl:element name="Column2"> <xsl:value-of select="regex-group(2)"/> </xsl:element> <xsl:element name="Column3"> <xsl:value-of select="regex-group(3)"/> </xsl:element> <xsl:element name="Column4"> <xsl:value-of select="regex-group(4)"/> </xsl:element> <xsl:element name="Column5"> <xsl:value-of select="regex-group(5)"/> </xsl:element> <xsl:element name="Column6"> <xsl:value-of select="regex-group(6)"/> </xsl:element> <xsl:element name="Column7"> <xsl:value-of select="regex-group(7)"/> </xsl:element> <xsl:element name="Column8"> <xsl:value-of select="regex-group(8)"/> </xsl:element> </xsl:element> </xsl:matching-substring> <xsl:non-matching-substring> <xsl:element name="UnmatchedInputLines"> <xsl:value-of select="."/> </xsl:element> </xsl:non-matching-substring> </xsl:analyze-string> </xsl:for-each> </xsl:element> </xsl:template> </xsl:stylesheet> -----Original Message----- From: Z W [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2008 6:17 PM To: Ant Users List Subject: csv to html via xslt or xslt2 task ? Hi ppl, I have a few rows of comma delimited csv file. 1204823515990,2091,Cl,200,OK,M,text,true 1204823518623,828,Su,200,OK,M,text,true 1204823519500,66,Se,200,OK,M,text,true 1204823519604,42,Se,OK,M,text,true and I like to transform it into html with xslt or xslt2. Is that possible ? Could someone provide a simple example to manipulate 2 field in a stylesheet ? I'm new to this hence such a question. Thanks --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
