主页 / coding / 问题 / 78784678
Accepted
Padd T
Asked: 2024-07-24 00:46:59 +0800 CST

XSLT 根据关键字段值重新分配序列号

  • 772

我需要将序列号 /MainHeader/Record/POSN 重新分配为 8001,8002....当我们在字段 /VAR 中有两个具有相同值的段时，如果 /Child-->段存在于 /Record 下，则必须将相同的序列号复制到 /Child 内的字段 /POSN。我的 XSLT 默认为所有记录生成序列号。

附有示例输入和输出。

输入：

<?xml version='1.0' encoding='UTF-8'?>
<MainHeader>
    <Record SEGMENT="1">
        <POSN>1000</POSN>
        <VAR>1234</VAR>
        <field>41</field>
        <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
      <Record SEGMENT="1">
        <POSN>2000</POSN>
        <VAR>45678</VAR>
        <field>41</field>
        <Child SEGMENT="1">
          <POSN>2000</POSN>
          <Union>UN</Union>
         </Child>
        <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
      <Record SEGMENT="1">
        <POSN>2000</POSN>
        <VAR>45678</VAR>
        <field>42</field>
        <Child SEGMENT="1">
          <POSN>2000</POSN>
          <Union>UN</Union>
         </Child>
        <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
        <Record SEGMENT="1">
        <POSN>3000</POSN>
        <VAR>778899</VAR>
        <field>43</field>
        <Child SEGMENT="1">
          <POSN>3000</POSN>
          <Union>UN</Union>
         </Child>
        <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
          <Record SEGMENT="1">
        <POSN>4000</POSN>
        <VAR>778899</VAR>
        <field>44</field>
         <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
          <Record SEGMENT="1">
        <POSN>5000</POSN>
        <VAR>118899</VAR>
        <field>45</field>
         <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
      
      
</MainHeader>

** 期望输出：**

<?xml version='1.0' encoding='UTF-8'?>
<MainHeader>
    <Record SEGMENT="1">
        <POSN>1000</POSN>
        <VAR>1234</VAR>
        <field>41</field>
        <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
      <Record SEGMENT="1">
        <POSN>8001</POSN>
        <VAR>45678</VAR>
        <field>41</field>
        <Child SEGMENT="1">
          <POSN>8001</POSN>
          <Union>UN</Union>
         </Child>
        <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
      <Record SEGMENT="1">
        <POSN>8002</POSN>
        <VAR>45678</VAR>
        <field>42</field>
        <Child SEGMENT="1">
          <POSN>8002</POSN>
          <Union>UN</Union>
         </Child>
        <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
        <Record SEGMENT="1">
        <POSN>8003</POSN>
        <VAR>778899</VAR>
        <field>43</field>
        <Child SEGMENT="1">
          <POSN>8003</POSN>
          <Union>UN</Union>
         </Child>
        <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
          <Record SEGMENT="1">
        <POSN>8004</POSN>
        <VAR>778899</VAR>
        <field>44</field>
         <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
          <Record SEGMENT="1">
        <POSN>5000</POSN>
        <VAR>118899</VAR>
        <field>45</field>
         <Subsegment SEGMENT="1">
          <Qua>value1</Qua>
        </Subsegment>
        <Subsegment SEGMENT="1">
          <Qua>Value2</Qua>
        </Subsegment>
      </Record>
      
      
</MainHeader>

** 我使用的 XSLT 如下：**

<xsl:stylesheet version="2.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

    <xsl:key name="segments-by-field" match="Record" use="POSN"/>

  <xsl:template match="/">
    <MainHeader>
      <xsl:for-each-group select="MainHeader/Record" group-by="POSN">
        <xsl:apply-templates select="current-group()"/>
      </xsl:for-each-group>
    </MainHeader>
  </xsl:template>

    <xsl:template match="Record">
   
    <Record>
        <POSN><xsl:value-of select="8000 + position()"/></POSN>
      <xsl:copy-of select="node()"/>
    </Record>
  </xsl:template>

</xsl:stylesheet>

请检查一次。

xslt

2 个回答

  1. 我认为以下 XSLT 3.0 样式表可以完成这项工作：

    <?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="3.0" 
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:xs="http://www.w3.org/2001/XMLSchema"
  exclude-result-prefixes="#all"
  expand-text="yes">

<xsl:mode on-no-match="shallow-copy"/>
  <xsl:strip-space elements="*"/>
  <xsl:output indent="yes"/>
  
  <xsl:template match="/MainHeader">
    <xsl:variable name="duplicates" as="xs:string*">
      <xsl:for-each-group select="//VAR" group-by=".">
        <xsl:if test="count(current-group()) gt 1">
          <xsl:sequence select="string(.)"/>
        </xsl:if>
      </xsl:for-each-group>
    </xsl:variable>
    <MainHeader>
      <xsl:iterate select="Record">
        <xsl:param name="seq" select="8001"/>
        <xsl:choose>
          <xsl:when test="VAR = $duplicates">
            <Record>
              <xsl:copy-of select="@*, POSN"/>
              <VAR>{$seq}</VAR>
              <xsl:copy-of select="* except (POSN, VAR)"/>
            </Record>
            <xsl:next-iteration>
              <xsl:with-param name="seq" select="$seq+1"/>
            </xsl:next-iteration>
          </xsl:when>
          <xsl:otherwise>
            <xsl:copy-of select="."/>
          </xsl:otherwise>
        </xsl:choose>       
      </xsl:iterate>
    </MainHeader>
  </xsl:template>
  
</xsl:stylesheet>
    • 1
  2. Best Answer

    这不是一项简单的任务，我怀疑是否有简单的解决方案。如果您希望编号在各组中连续，则对记录进行分组无济于事。

    或许可以尝试类似这样的方法：

    XSLT 2.0

    <xsl:stylesheet version="2.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:strip-space elements="*"/>

<xsl:key name="rec-by-var" match="Record" use="VAR" />
<xsl:variable name="rec-ids" select="//Record[count(key('rec-by-var', VAR)) > 1]/generate-id()" />

<!-- identity transform -->
<xsl:template match="@*|node()" mode="#all">
    <xsl:copy>
        <xsl:apply-templates select="@*|node()" mode="#current"/>
    </xsl:copy>
</xsl:template>

<xsl:template match="Record[generate-id()=$rec-ids]">
    <xsl:copy>
        <xsl:apply-templates select="@*|node()" mode="multi">
            <xsl:with-param name="new-posn" select="8000 + index-of($rec-ids, generate-id())" tunnel="yes"/>
        </xsl:apply-templates>  
    </xsl:copy>
</xsl:template>

<xsl:template match="POSN" mode="multi">
    <xsl:param name="new-posn" tunnel="yes"/>
    <xsl:copy>
        <xsl:value-of select="$new-posn"/>
    </xsl:copy>
</xsl:template>

</xsl:stylesheet>
    • 0

相关问题