Hi guys
I was able to convert the data from csv to xml. Now I want to build groups of
the elements such as the sample bellow.
Each 5 elements should be assigned to a clfPackage element:
This is the CSV as xml:
<?xml version="1.0" encoding="UTF-8"?>
<xmlData>
<element>EN</element>
<element>01</element>
<element>text</element>
<element>U</element>
<element>2013028074426</element>
<element>SE</element>
<element>06</element>
<element>text</element>
<element>M</element>
<element>2013011234457</element>
.......
</xmlData>
This is what must be created:
<clfPackage>
<Country><xsl:value-of select="xmlData/element"/></CountryCode>
//must be the first element
<number><xsl:value-of select="xmlData/element"/></ClearingNumber>
//must be the secound element
<Description1><xsl:value-of select="xmlData/element"/></Description>
<ChangeMode><xsl:value-of select="xmlData/element"/></ChangeMode>
<Modification><xsl:value-of select="xmlData/element"/></Modification>
</clfPackage>
Best regards
Henry
----- Ursprüngliche Message -----
Von: Michael Kay <mike(_at_)saxonica(_dot_)com>
An: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
CC:
Gesendet: 16:47 Mittwoch, 26.Juni 2013
Betreff: Re: [xsl] csv data to xml
On 26 Jun 2013, at 15:21, henry human wrote:
Hi I was not able to run get this xslt sample runing! When I try it with
Saxon 9.1.0 and (call it in Stylus Studio) I got the known
error:ontent is not allowed in prolog.
That means you're doing it wrong; you're somehow putting the CSV file through
an XML parser. Probably because you are supplying it as the main input to the
transformation, rather than merely a secondary file to be read with
unparsed-text().
Michael Kay
Saxonica
?
This was my csv file test.csv
USA,AA,Comp. 1,U,012345,L987
USA,BB,Comp.2,Z,034567888888,F098
USA,CC,Comp 3,M,034847474747,F098
----- Ursprüngliche Message -----
Von: Andrew Welch <andrew(_dot_)j(_dot_)welch(_at_)gmail(_dot_)com>
An: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
CC:
Gesendet: 15:15 Dienstag, 25.Juni 2013
Betreff: Re: [xsl] csv data to xml
Use unparsed-text() to read the csv, then use tokenize() to split it
into lines, iterate over each line outputting a <Segment>, then
tokenize() the $line into $tokens, and use fill-in-the-blanks style to
populate the elements.
Basically this:
http://andrewjwelch.com/code/xslt/csv/csv-to-xml_v2.html
--
Andrew Welch
http://andrewjwelch.com/
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--