xslt - 使用 XSLT 删除多个 XML 节点
问题描述
我正在尝试从 XML 文件中删除 2 个根节点,但似乎无法正确处理。我试图删除第一部分,但无济于事。
我希望文件是这样的:
[{
"PartNumber" : "000096",
"Location" : "A000",
"Description" : "TEST OF RAMIS",
"UnitOfMeasure" : "EA",
"PartType" : "1",
"FixedLeadTime" : "1",
"MaterialType" : "Filling & Mixing Eq"
},{
"PartNumber" : "000096",
"Location" : "A000",
"Description" : "TEST OF RAMIS",
"UnitOfMeasure" : "EA",
"PartType" : "1",
"FixedLeadTime" : "1",
"MaterialType" : "Filling & Mixing Eq"
}]
但它来了:
{
"ns1:ZZMRP_Parts" : { "Part" :[{
"PartNumber" : "000096",
"Location" : "A000",
"Description" : "TEST OF RAMIS",
"UnitOfMeasure" : "EA",
"PartType" : "1",
"FixedLeadTime" : "1",
"MaterialType" : "Filling & Mixing Eq"
},{
"PartNumber" : "000096",
"Location" : "A000",
"Description" : "TEST OF RAMIS",
"UnitOfMeasure" : "EA",
"PartType" : "1",
"FixedLeadTime" : "1",
"MaterialType" : "Filling & Mixing Eq"
}] }}
我需要的是"ns1:ZZMRP_Parts" : { "Part" :[{
删除的部分。
来自评论:输入样本
<ns1:DDMRP_Parts xmlns:ns1="urn:za.xxxxxxxx.com:supplychain:3rdp:transdata">
<Part>
<PartNumber>000096</PartNumber>
<Location>A000</Location>
<Description>TEST OF RAMIS</Description>
<UnitOfMeasure>EA</UnitOfMeasure>
<PartType>1</PartType>
<FixedLeadTime>1</FixedLeadTime>
<MaterialType>Filling & Mixing Eq</MaterialType>
</Part>
<Part>
<PartNumber>000096</PartNumber>
<Location>A000</Location>
<Description>TEST OF RAMIS</Description>
<UnitOfMeasure>EA</UnitOfMeasure>
<PartType>1</PartType>
<FixedLeadTime>1</FixedLeadTime>
<MaterialType>Filling & Mixing Eq</MaterialType>
</Part>
</ns1:DDMRP_Parts>
解决方案
XSLT 3 可以处理 JSON,而使用 XPath 3.1,您可以轻松地从您拥有的更复杂的输入 JSON 中选择您感兴趣的部分:
<?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"
exclude-result-prefixes="#all"
version="3.0">
<xsl:output method="json" indent="yes"/>
<xsl:template match="json">
<xsl:sequence select="parse-json(.)('ns1:ZZMRP_Parts')?Part"/>
</xsl:template>
</xsl:stylesheet>
假设输入像
<?xml version="1.0" encoding="UTF-8"?>
<json><![CDATA[
{
"ns1:ZZMRP_Parts" : { "Part" :[{
"PartNumber" : "000096",
"Location" : "A000",
"Description" : "TEST OF RAMIS",
"UnitOfMeasure" : "EA",
"PartType" : "1",
"FixedLeadTime" : "1",
"MaterialType" : "Filling & Mixing Eq"
},{
"PartNumber" : "000096",
"Location" : "A000",
"Description" : "TEST OF RAMIS",
"UnitOfMeasure" : "EA",
"PartType" : "1",
"FixedLeadTime" : "1",
"MaterialType" : "Filling & Mixing Eq"
}] }}
]]></json>
推荐阅读
- c# - 范围报告生成两个 HTML 报告
- java - 如何修复'java.sql.SQLException:ORA-01017:用户名/密码无效;spring-boot 中的登录被拒绝错误
- javascript - 通过@符号按字符串拆分数组对象
- excel - 在 Excel 中对数字和字母求和
- django - 在渲染前保存压缩图像与压缩图像
- python - 如何从文本文件中获取一些值到列表中然后写入?
- sql - PostgreSQL - 从长格式到宽格式
- angular - 在 Angular 中,如何将组件转换为微服务?
- c# - 异步处理对 ASPNET Core API 的请求
- zend-framework3 - 如何从数据库(mysql)中填充字段集中的选择元素