我想将CSV以下的格式转换为XML
CSV输入示例
01,TeacherHeader1
02,StudentHeader1
03,SubjectHeader1
10,Grade1,Score99
10,Grade2,Score99
48,SubjectTrailer1
49,StudentTrailer1
02,StudentHeader2
03,SubjectHeader1
10,Grade1,Score50
10,Grade2,Score50
48,SubjectTrailer1
49,StudentTrailer2
50,TeacherTrailer1
输出应为
<FileHeader>
<id>01</id>
<name>TeacherHeader1</name>
</FileHeader>
<GroupRecord>
<GroupHeader>
<id>02</id>
<name>StudentHeader1</name>
</GroupHeader>
<AccountRecord>
<AccountHeader>
<id>03</id>
<name>SubjectHeader1</name>
</AccountHeader>
<AccountDetails>
<Details>
<id>10</id>
<name>Grade1</name>
<value>Score99</value>
</Details>
<Details>
<id>10</id>
<name>Grade2</name>
<value>Score99</value>
</Details>
</AccountDetails>
<AccountTrailer>
<id>48</id>
<name>SubjectTrailer1</name>
</AccountTrailer>
</AccountRecord>
<GroupTrailer>
<id>49</id>
<name>StudentTrailer1</name>
</GroupTrailer>
</GroupRecord>
<GroupRecord>
<GroupHeader>
<id>02</id>
<name>StudentHeader2</name>
</GroupHeader>
<AccountRecord>
<AccountHeader>
<id>03</id>
<name>SubjectHeader1</name>
</AccountHeader>
<AccountDetails>
<Details>
<id>10</id>
<name>Grade1</name>
<value>Score99</value>
</Details>
<Details>
<id>10</id>
<name>Grade2</name>
<value>Score99</value>
</Details>
</AccountDetails>
<AccountTrailer>
<id>48</id>
<name>SubjectTrailer1</name>
</AccountTrailer>
</AccountRecord>
<GroupTrailer>
<id>49</id>
<name>StudentTrailer2</name>
</GroupTrailer>
</GroupRecord>
<FileTrailer>
<id>50</id>
<name>TeacherTrailer1</name>
</FileTrailer>
哪里
01 = FileHeader
02 = GroupHeader (grouped inside GroupRecord)
03 = AccountHeader (grouped inside AccountRecord)
10 = Details (grouped inside AccountDetails)
48 = AccountTrailer (grouped inside AccountRecord)
49 = GroupTrailer (group inside GroupRecord)
50 = FileTrailer
我想将上面的CSV转换为结构正确的XML,如上所述。任何帮助将不胜感激。谢谢。
正如我在评论中所说,您可以使用处理文本文件unparsed-text
并将tokenize
其转换为XML(或者在XSLT 3中使用unparsed-text-lines
,tokenize
如果可用的话),然后其余任务可以使用xsl:for-each-group
s 嵌套完成,甚至可以使用一两个一旦建立了规则模式,就执行递归函数;以下尝试拼出嵌套的for-each-group
s:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
expand-text="yes"
xmlns:mf="http://example.com/mf"
exclude-result-prefixes="#all"
version="3.0">
<xsl:param name="data" as="xs:string">01,TeacherHeader1
02,StudentHeader1
03,SubjectHeader1
10,Grade1,Score99
10,Grade2,Score99
48,SubjectTrailer1
49,StudentTrailer1
02,StudentHeader2
03,SubjectHeader1
10,Grade1,Score50
10,Grade2,Score50
48,SubjectTrailer1
49,StudentTrailer2
50,TeacherTrailer1</xsl:param>
<xsl:param name="header-ids" as="xs:string*"
select="'01', '02', '03', '10', '48', '49', '50'"/>
<xsl:param name="header-names" as="xs:string*"
select="'FileHeader ', 'GroupHeader', 'AccountHeader', 'Details', 'AccountTrailer', 'GroupTrailer', 'FileTrailer'"/>
<xsl:variable name="lines">
<xsl:for-each select="tokenize($data, '\r?\n')">
<line>
<xsl:variable name="tokens" as="xs:string*" select="tokenize(., ',')"/>
<id>{$tokens[1]}</id>
<name>{$tokens[2]}</name>
<xsl:if test="$tokens[3]">
<value>{$tokens[3]}</value>
</xsl:if>
</line>
</xsl:for-each>
</xsl:variable>
<xsl:mode on-no-match="shallow-copy"/>
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/" name="xsl:initial-template">
<xsl:for-each-group select="$lines/line" group-starting-with="line[id = '01']">
<File>
<xsl:apply-templates select="."/>
<xsl:for-each-group select="current-group() except ." group-ending-with="line[id = '50']">
<xsl:for-each-group select="current-group()[position() lt last()]" group-starting-with="line[id = '02']">
<GroupRecord>
<xsl:apply-templates select="."/>
<xsl:for-each-group select="current-group() except ." group-ending-with="line[id = '49']">
<xsl:for-each-group select="current-group()[position() lt last()]" group-starting-with="line[id = '03']">
<AccountRecord>
<xsl:apply-templates select="."/>
<AccountDetails>
<xsl:apply-templates select="(current-group() except .)[id != '48']"/>
</AccountDetails>
<xsl:apply-templates select="current-group()[id = '48']"/>
</AccountRecord>
</xsl:for-each-group>
<xsl:apply-templates select="current-group()[last()]"/>
</xsl:for-each-group>
</GroupRecord>
</xsl:for-each-group>
<xsl:apply-templates select="current-group()[last()]"/>
</xsl:for-each-group>
</File>
</xsl:for-each-group>
</xsl:template>
<xsl:template match="line">
<xsl:element name="{$header-names[index-of($header-ids, current()/id)]}">
<xsl:apply-templates/>
</xsl:element>
</xsl:template>
</xsl:stylesheet>
https://xsltfiddle.liberty-development.net/gWEaSv8。为了示例的完整性和紧凑性,内联了示例数据,但是您当然可以<xsl:param name="data" as="xs:string" select="unparsed-text('file.txt')"/>
代替使用。我还使用了xsl:mode
声明和name="xsl:initial-template"
XSLT 3这两个功能,您需要使用它们来适应XSLT 2处理器以阐明身份转换并使用其他模板名称,例如name="main"
作为代码的入口点。我还在<id>{$tokens[1]}</id>
那里使用了文本值模板,对于XSLT 2处理器,您需要使用eg <id><xsl:value-of select="$tokens[1]"/</id>
。
感谢Martin,我必须删除XSLT 2不支持的所有功能。对于name =“ xsl:initial-template”,我不必复制它,因为我们有一个标准的后端解决方案,可以将CSV转换为XML。一个基本的。因此,此XSL的实际输入是一个简单的XML,每个元素包含CSV中的每一行(例如:xdata的<data> <record> <field1> 01,TeacherHeader1 </ field1> </ record> </ data>:模式,我还没有考虑过如何将其转换为XSLT 2,但是此解决方案几乎解决了我关于分组技术(带有标题/尾部)的问题