blocks|key|2291830|text|正如我在评论中所说，这是一项可怕的工作，结果的质量将取决于您的数据的一致性。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2291831|假设：|2291832|街道名称(|2291833|)第一个单词(并且仅第一个单词)是街道号码；街道名称第二个单词可以是街道方向标识符，从街道方向的已知列表中|ordered-list-item|2291834|后面跟随街道类型标识符，从街道类型标识符的已知列表|2291835|2291836|2291837|您可以使用以下样式表作为起点：|2291838|XSLT1.0+(%2BEXSLT节点集)|offset|length|style|BOLD|2291839|<xsl:stylesheet+version="1.0"+
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:exsl="http://exslt.org/common"
extension-element-prefixes="exsl">
<xsl:output+method="xml"+version="1.0"+encoding="UTF-8"+indent="yes"/>
<xsl:strip-space+elements="*"/>


<xsl:template+match="@*%7Cnode()">
++++<xsl:copy>
++++++++<xsl:apply-templates+select="@*%7Cnode()"/>
++++</xsl:copy>
</xsl:template>

<xsl:template+match="Field[@Name='address']">
++++
++++<xsl:variable+name="tokens">
++++++++<xsl:call-template+name="tokenize">
++++++++++++<xsl:with-param+name="text"+select="."/>
++++++++</xsl:call-template>
++++</xsl:variable>
++++<xsl:variable+name="words"+select="exsl:node-set($tokens)/token"+/>

++++
++++<xsl:variable+name="street-direction-exists"+select="$words[2]='N'+or+$words[2]='E'+or+$words[2]='S'+or+$words[2]='W'+or+$words[2]='NE'+or+$words[2]='NW'+or+$words[2]='SE'+or+$words[2]='SW'"+/>

++++
++++<xsl:variable+name="street-type-index">
++++++++<xsl:call-template+name="get-street-type-index">
++++++++++++<xsl:with-param+name="words"+select="$words"/>
++++++++</xsl:call-template>
++++</xsl:variable>

++++
++++<Address>
++++++++<HouseNumber>
++++++++++++<xsl:value-of+select="$words[1]"/>
++++++++</HouseNumber>
++++++++<xsl:if+test="$street-direction-exists">
++++++++++++<StreetDirection>
++++++++++++++++<xsl:value-of+select="$words[2]"/>
++++++++++++</StreetDirection>
++++++++</xsl:if>
++++++++<StreetName>++++++++++++
++++++++++++<xsl:for-each+select="$words[1+%2B+$street-direction-exists+&lt;+position()+and+position()+&lt;+$street-type-index]">
++++++++++++++++<xsl:value-of+select="."/>
++++++++++++++++<xsl:if+test="position()+!=+last()">
++++++++++++++++++++<xsl:text>+</xsl:text>
++++++++++++++++</xsl:if>
++++++++++++</xsl:for-each>
++++++++</StreetName>
++++++++<StreetType>
++++++++++++<xsl:value-of+select="$words[number($street-type-index)]"/>+++++++++++++++++++++
++++++++</StreetType>
++++++++<xsl:if+test="count($words)+>+$street-type-index">
++++++++++++<Unit>
++++++++++++++++<xsl:for-each+select="$words[position()+>+$street-type-index]">
++++++++++++++++++++<xsl:value-of+select="."/>
++++++++++++++++++++<xsl:if+test="position()+!=+last()">
++++++++++++++++++++++++<xsl:text>+</xsl:text>
++++++++++++++++++++</xsl:if>
++++++++++++++++</xsl:for-each>
++++++++++++</Unit>
++++++++</xsl:if>
++++</Address>
</xsl:template>

<xsl:template+name="tokenize">
++++<xsl:param+name="text"/>
++++<xsl:param+name="delimiter"+select="'+'"/>
++++<token>
++++++++<xsl:value-of+select="substring-before(concat($text,+$delimiter),+$delimiter)"+/>
++++</token>
++++<xsl:if+test="contains($text,+$delimiter)">
++++++++
++++++++<xsl:call-template+name="tokenize">
++++++++++++<xsl:with-param+name="text"+select="substring-after($text,+$delimiter)"/>
++++++++</xsl:call-template>
++++</xsl:if>
</xsl:template>

<xsl:template+name="get-street-type-index">
++++<xsl:param+name="words"/>
++++<xsl:variable+name="street-types">
++++++++<street-type>AVE</street-type>
++++++++<street-type>STR</street-type>
++++++++
++++</xsl:variable>
++++<xsl:choose>
++++++++<xsl:when+test="$words[last()]+=+exsl:node-set($street-types)/street-type">
++++++++++++<xsl:value-of+select="count($words)"/>
++++++++</xsl:when>
++++++++<xsl:when+test="$words">
++++++++++++
++++++++++++<xsl:call-template+name="get-street-type-index">
++++++++++++++++<xsl:with-param+name="words"+select="$words[position()+!=+last()]"/>
++++++++++++</xsl:call-template>
++++++++</xsl:when>
++++</xsl:choose>
</xsl:template>

</xsl:stylesheet>|code-block|syntax|javascript|2291840|应用于以下测试输入：|2291841|XML|2291842|<Fields>
++++<Field+Name="address">123+Old+Oak+Tree+AVE</Field>
++++<Field+Name="address">45B+NE+Broadway+STR</Field>
++++<Field+Name="address">6789+Maple+Syrup+AVE+Room+800</Field>
++++<Field+Name="address">1024+W+Three+Elm+Trees+AVE+APT+321</Field>
++++<Field+Name="address">1024+False+AVE+Maria+STR+Unit+8071</Field>
</Fields>|2291843|结果将是：|2291844|结果|2291845|<?xml+version="1.0"+encoding="utf-16"?>
<Fields>
++<Address>
++++<HouseNumber>123</HouseNumber>
++++<StreetName>Old+Oak+Tree</StreetName>
++++<StreetType>AVE</StreetType>
++</Address>
++<Address>
++++<HouseNumber>45B</HouseNumber>
++++<StreetDirection>NE</StreetDirection>
++++<StreetName>Broadway</StreetName>
++++<StreetType>STR</StreetType>
++</Address>
++<Address>
++++<HouseNumber>6789</HouseNumber>
++++<StreetName>Maple+Syrup</StreetName>
++++<StreetType>AVE</StreetType>
++++<Unit>Room+800</Unit>
++</Address>
++<Address>
++++<HouseNumber>1024</HouseNumber>
++++<StreetDirection>W</StreetDirection>
++++<StreetName>Three+Elm+Trees</StreetName>
++++<StreetType>AVE</StreetType>
++++<Unit>APT+321</Unit>
++</Address>
++<Address>
++++<HouseNumber>1024</HouseNumber>
++++<StreetName>False+AVE+Maria</StreetName>
++++<StreetType>STR</StreetType>
++++<Unit>Unit+8071</Unit>
++</Address>
</Fields>|2291846|2291847|EXSLT：你可能需要使用微软自己的node-set()扩展函数，而不是EXSLT.|CODE|2291848|entityMap^0|0|0|0|1|1|0|0|0|0|J|0|0|0|0|3|0|0|0|0|2|0|0|0|I|A|0^^$0|@$1|2|3|4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1J|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|1K|8|@]|9|@]|A|$]]|$1|I|3|J|5|H|7|1L|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1O|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1P|8|@$Q|1Q|R|1R|S|T]]|9|@]|A|$]]|$1|U|3|V|5|W|7|1S|8|@]|9|@]|A|$X|Y]]|$1|Z|3|10|5|6|7|1T|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|1U|8|@$Q|1V|R|1W|S|T]]|9|@]|A|$]]|$1|13|3|14|5|W|7|1X|8|@]|9|@]|A|$X|Y]]|$1|15|3|16|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|17|3|18|5|6|7|1Z|8|@$Q|20|R|21|S|T]]|9|@]|A|$]]|$1|19|3|1A|5|W|7|22|8|@]|9|@]|A|$X|Y]]|$1|1B|3|-4|5|6|7|23|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|6|7|24|8|@$Q|25|R|26|S|1E]]|9|@]|A|$]]|$1|1F|3|-4|5|6|7|27|8|@]|9|@]|A|$]]]|1G|$]]

As I said in the comments, this is an awful lot of work and the quality of the result will depend on how consistent your data is.

Assuming that:

<ol>
<li>the first word (and only the first word) is the street number;</li>
<li>the second word may be a street direction identifier, from a known list of street direction identifiers;</li>
<li>the street name is followed by a street type identifier, from a known list of street type identifiers,</li>
</ol>

you could use the following stylesheet as your starting point:

XSLT 1.0 (+EXSLT node-set)

<pre><code>&lt;xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:exsl="http://exslt.org/common"
extension-element-prefixes="exsl"&gt;
&lt;xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/&gt;
&lt;xsl:strip-space elements="*"/&gt;

&lt;!-- identity transform --&gt;
&lt;xsl:template match="@*|node()"&gt;
 &lt;xsl:copy&gt;
 &lt;xsl:apply-templates select="@*|node()"/&gt;
 &lt;/xsl:copy&gt;
&lt;/xsl:template&gt;

&lt;xsl:template match="Field[@Name='address']"&gt;
 &lt;!-- tokenize to words --&gt;
 &lt;xsl:variable name="tokens"&gt;
 &lt;xsl:call-template name="tokenize"&gt;
 &lt;xsl:with-param name="text" select="."/&gt;
 &lt;/xsl:call-template&gt;
 &lt;/xsl:variable&gt;
 &lt;xsl:variable name="words" select="exsl:node-set($tokens)/token" /&gt;

 &lt;!-- street direction exists? --&gt;
 &lt;xsl:variable name="street-direction-exists" select="$words[2]='N' or $words[2]='E' or $words[2]='S' or $words[2]='W' or $words[2]='NE' or $words[2]='NW' or $words[2]='SE' or $words[2]='SW'" /&gt;

 &lt;!-- find position of street type --&gt;
 &lt;xsl:variable name="street-type-index"&gt;
 &lt;xsl:call-template name="get-street-type-index"&gt;
 &lt;xsl:with-param name="words" select="$words"/&gt;
 &lt;/xsl:call-template&gt;
 &lt;/xsl:variable&gt;

 &lt;!-- output --&gt;
 &lt;Address&gt;
 &lt;HouseNumber&gt;
 &lt;xsl:value-of select="$words[1]"/&gt;
 &lt;/HouseNumber&gt;
 &lt;xsl:if test="$street-direction-exists"&gt;
 &lt;StreetDirection&gt;
 &lt;xsl:value-of select="$words[2]"/&gt;
 &lt;/StreetDirection&gt;
 &lt;/xsl:if&gt;
 &lt;StreetName&gt; 
 &lt;xsl:for-each select="$words[1 + $street-direction-exists &amp;lt; position() and position() &amp;lt; $street-type-index]"&gt;
 &lt;xsl:value-of select="."/&gt;
 &lt;xsl:if test="position() != last()"&gt;
 &lt;xsl:text&gt; &lt;/xsl:text&gt;
 &lt;/xsl:if&gt;
 &lt;/xsl:for-each&gt;
 &lt;/StreetName&gt;
 &lt;StreetType&gt;
 &lt;xsl:value-of select="$words[number($street-type-index)]"/&gt; 
 &lt;/StreetType&gt;
 &lt;xsl:if test="count($words) &gt; $street-type-index"&gt;
 &lt;Unit&gt;
 &lt;xsl:for-each select="$words[position() &gt; $street-type-index]"&gt;
 &lt;xsl:value-of select="."/&gt;
 &lt;xsl:if test="position() != last()"&gt;
 &lt;xsl:text&gt; &lt;/xsl:text&gt;
 &lt;/xsl:if&gt;
 &lt;/xsl:for-each&gt;
 &lt;/Unit&gt;
 &lt;/xsl:if&gt;
 &lt;/Address&gt;
&lt;/xsl:template&gt;

&lt;xsl:template name="tokenize"&gt;
 &lt;xsl:param name="text"/&gt;
 &lt;xsl:param name="delimiter" select="' '"/&gt;
 &lt;token&gt;
 &lt;xsl:value-of select="substring-before(concat($text, $delimiter), $delimiter)" /&gt;
 &lt;/token&gt;
 &lt;xsl:if test="contains($text, $delimiter)"&gt;
 &lt;!-- recursive call --&gt;
 &lt;xsl:call-template name="tokenize"&gt;
 &lt;xsl:with-param name="text" select="substring-after($text, $delimiter)"/&gt;
 &lt;/xsl:call-template&gt;
 &lt;/xsl:if&gt;
&lt;/xsl:template&gt;

&lt;xsl:template name="get-street-type-index"&gt;
 &lt;xsl:param name="words"/&gt;
 &lt;xsl:variable name="street-types"&gt;
 &lt;street-type&gt;AVE&lt;/street-type&gt;
 &lt;street-type&gt;STR&lt;/street-type&gt;
 &lt;!-- add more types here (or use an external XML document for them) --&gt;
 &lt;/xsl:variable&gt;
 &lt;xsl:choose&gt;
 &lt;xsl:when test="$words[last()] = exsl:node-set($street-types)/street-type"&gt;
 &lt;xsl:value-of select="count($words)"/&gt;
 &lt;/xsl:when&gt;
 &lt;xsl:when test="$words"&gt;
 &lt;!-- recursive call --&gt;
 &lt;xsl:call-template name="get-street-type-index"&gt;
 &lt;xsl:with-param name="words" select="$words[position() != last()]"/&gt;
 &lt;/xsl:call-template&gt;
 &lt;/xsl:when&gt;
 &lt;/xsl:choose&gt;
&lt;/xsl:template&gt;

&lt;/xsl:stylesheet&gt;
</code></pre>

Applied to the following test input:

XML

<pre><code>&lt;Fields&gt;
 &lt;Field Name="address"&gt;123 Old Oak Tree AVE&lt;/Field&gt;
 &lt;Field Name="address"&gt;45B NE Broadway STR&lt;/Field&gt;
 &lt;Field Name="address"&gt;6789 Maple Syrup AVE Room 800&lt;/Field&gt;
 &lt;Field Name="address"&gt;1024 W Three Elm Trees AVE APT 321&lt;/Field&gt;
 &lt;Field Name="address"&gt;1024 False AVE Maria STR Unit 8071&lt;/Field&gt;
&lt;/Fields&gt;
</code></pre>

the result will be:

Result

<pre><code>&lt;?xml version="1.0" encoding="utf-16"?&gt;
&lt;Fields&gt;
 &lt;Address&gt;
 &lt;HouseNumber&gt;123&lt;/HouseNumber&gt;
 &lt;StreetName&gt;Old Oak Tree&lt;/StreetName&gt;
 &lt;StreetType&gt;AVE&lt;/StreetType&gt;
 &lt;/Address&gt;
 &lt;Address&gt;
 &lt;HouseNumber&gt;45B&lt;/HouseNumber&gt;
 &lt;StreetDirection&gt;NE&lt;/StreetDirection&gt;
 &lt;StreetName&gt;Broadway&lt;/StreetName&gt;
 &lt;StreetType&gt;STR&lt;/StreetType&gt;
 &lt;/Address&gt;
 &lt;Address&gt;
 &lt;HouseNumber&gt;6789&lt;/HouseNumber&gt;
 &lt;StreetName&gt;Maple Syrup&lt;/StreetName&gt;
 &lt;StreetType&gt;AVE&lt;/StreetType&gt;
 &lt;Unit&gt;Room 800&lt;/Unit&gt;
 &lt;/Address&gt;
 &lt;Address&gt;
 &lt;HouseNumber&gt;1024&lt;/HouseNumber&gt;
 &lt;StreetDirection&gt;W&lt;/StreetDirection&gt;
 &lt;StreetName&gt;Three Elm Trees&lt;/StreetName&gt;
 &lt;StreetType&gt;AVE&lt;/StreetType&gt;
 &lt;Unit&gt;APT 321&lt;/Unit&gt;
 &lt;/Address&gt;
 &lt;Address&gt;
 &lt;HouseNumber&gt;1024&lt;/HouseNumber&gt;
 &lt;StreetName&gt;False AVE Maria&lt;/StreetName&gt;
 &lt;StreetType&gt;STR&lt;/StreetType&gt;
 &lt;Unit&gt;Unit 8071&lt;/Unit&gt;
 &lt;/Address&gt;
&lt;/Fields&gt;
</code></pre>

<hr>

Note: You may need to use Microsoft's own <code>node-set()</code> extension function, instead of EXSLT.

I am transferring data from one xml format to another with xslt 1.0. In the input xml, address is in a single field as a string separated by spaces. As far as I can tell, it can come in the following formats considering the identifiers in brackets [] are optional.

<pre><code>&lt;Field Name="address"...&gt;number [cardinal-dir] name st-type [unit#]&lt;/Field&gt;
</code></pre>

OR

<pre><code>&lt;Field Name="address"...&gt;number [cardinal-dir] name st-type APT APT#&lt;/Field&gt;
</code></pre>

so the data may look like:
 "123 3RD AVE" or "123 NE 3RD AVE" or "123 NE 3RD AVE APT 321" ... you get the picture.

And I need it to appropriately populate the following output format:

<pre><code>&lt;mstns:Address&gt;
 &lt;mstns:HouseNumber&gt;123&lt;/mstns:HouseNumber&gt;
 &lt;mstns:StreetName&gt;NE&lt;/mstns:StreetName&gt;
 &lt;mstns:StreetType&gt;AVE&lt;/mstns:StreetType&gt;
 &lt;mstns:Apt&gt;APT&lt;/mstns:Apt&gt;
&lt;/mstns:Address&gt;
</code></pre>

I've seen some similar posts about tokenizing strings in xlst 1.0 but combined with the variable input I'm a bit lost.

XSLT 1.0 split variable string to populate specific tags

我使用XSLT1.0将数据从一种xml格式转换为另一种格式。在输入xml中，address作为由空格分隔的字符串出现在单个字段中。据我所知，考虑到括号[]中的标识符是可选的，它可以采用以下格式。<Field Name="address"...>number [cardinal-dir] name st-type [un...

问XSLT 1.0拆分变量字符串以填充特定标记
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问XSLT 1.0拆分变量字符串以填充特定标记EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问XSLT 1.0拆分变量字符串以填充特定标记
EN