如何引用 XML 标签内包含的特殊字符？

Question

尝试一下，你需要安装recode包：

sudo apt install recode

备份原始文件。

我目前已经实现了这个目标：

代码：

#!/bin/bash

# create a function to parse the files
f() {
  # get the original text between the tags inside DESCRIPTION
  decoded="$(sed -n '/<DESCRIPTION>/p;' "$1" | sed 's:<\([^>]*\)>::g' | sed 's/^[[:blank:]]*\|[[:blank:]]*$//g')"

  # get the encoded text from the decoded text
  encoded="$(echo "$decoded" | recode ..html | sed 's:&lt;DESCRIPTION&gt;\(.*\)&lt;/DESCRIPTION&gt;:\1:')"

  # encode everything inside DESCRIPTION to temporal file
  awk '/DESCRIPTION/{"echo \""$0"\" | recode ..html" | getline $0;}1' "$1" > output.xml

  # replace the encoded with the decoded
  [[ ! -z "$encoded" ]] && sed -i "s/$encoded/$decoded/" output.xml

  # decode DESCRIPTION tags
  sed "s:&lt;\([^;]*\)DESCRIPTION&gt;:<\1DESCRIPTION>:g" output.xml >> result.xml 
}

# create result file
> result.xml

# split the source file into <SHOPITEM> chunks
csplit --suffix-format="%d.FOO" file.xml '/<SHOPITEM>/' '{*}' 2>&1 > /dev/null

# loop over the "chunk" files
for i in *.FOO; do
  # apply the function to the "chunk" file
  f "$i"
  # remove "chunk" file
  rm "$i"
done

# remove temporal file
rm output.xml

然后：

$ cat result.xml

<?xml version="1.0" encoding="utf-8"?>
<SHOP><GENERATED>2021-02-05T14:19:48+01:00</GENERATED>
<SHOPITEM>
    <ITEM_ID>ABF644B</ITEM_ID>
    <PRODUCTNAME>LÁHEV NA VODU "BISFREE ECO" 550ML, HNĚDÁ</PRODUCTNAME>
    <DESCRIPTION>&lt;p&gt;Konvice s pokličkou smalt je vhodná ke každodennímu použití. Lze ji mýt v myčce na nádobí a je vhodná pro plynové, elektrické sporáky a indukci. Objem 2 l, v červené barvě s bílým puntíkem.&lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt; &lt;/p&gt;</DESCRIPTION>
    <URL>https://b2b.utc.cz/lahev-na-vodu-bisfree-eco-550ml-hneda/347058p/</URL>
    <IMGURL>https://b2b.utc.cz/bin/product/4/ABF644B.jpg</IMGURL>
    <IMGURL_ALTERNATIVE></IMGURL_ALTERNATIVE>
    <ORIGINAL_PRICE_VAT>199.00</ORIGINAL_PRICE_VAT>
    <PURCHASE_PRICE_VAT>164.46</PURCHASE_PRICE_VAT>
    <MANUFACTURER>LOCKNLOCK</MANUFACTURER>
    <CATEGORY>STOLOVÁNÍ | PŘÍPRAVA NÁPOJŮ | SPORTOVNÍ LAHVE</CATEGORY>
    <EAN>8803733138772</EAN>
    <ITEMGROUP_ID></ITEMGROUP_ID>
    <PRICE_VAT>199.00</PRICE_VAT>
</SHOPITEM>

Answer 1

尝试一下，你需要安装recode包：

sudo apt install recode

备份原始文件。

我目前已经实现了这个目标：

代码：

#!/bin/bash

# create a function to parse the files
f() {
  # get the original text between the tags inside DESCRIPTION
  decoded="$(sed -n '/<DESCRIPTION>/p;' "$1" | sed 's:<\([^>]*\)>::g' | sed 's/^[[:blank:]]*\|[[:blank:]]*$//g')"

  # get the encoded text from the decoded text
  encoded="$(echo "$decoded" | recode ..html | sed 's:&lt;DESCRIPTION&gt;\(.*\)&lt;/DESCRIPTION&gt;:\1:')"

  # encode everything inside DESCRIPTION to temporal file
  awk '/DESCRIPTION/{"echo \""$0"\" | recode ..html" | getline $0;}1' "$1" > output.xml

  # replace the encoded with the decoded
  [[ ! -z "$encoded" ]] && sed -i "s/$encoded/$decoded/" output.xml

  # decode DESCRIPTION tags
  sed "s:&lt;\([^;]*\)DESCRIPTION&gt;:<\1DESCRIPTION>:g" output.xml >> result.xml 
}

# create result file
> result.xml

# split the source file into <SHOPITEM> chunks
csplit --suffix-format="%d.FOO" file.xml '/<SHOPITEM>/' '{*}' 2>&1 > /dev/null

# loop over the "chunk" files
for i in *.FOO; do
  # apply the function to the "chunk" file
  f "$i"
  # remove "chunk" file
  rm "$i"
done

# remove temporal file
rm output.xml

然后：

$ cat result.xml

<?xml version="1.0" encoding="utf-8"?>
<SHOP><GENERATED>2021-02-05T14:19:48+01:00</GENERATED>
<SHOPITEM>
    <ITEM_ID>ABF644B</ITEM_ID>
    <PRODUCTNAME>LÁHEV NA VODU "BISFREE ECO" 550ML, HNĚDÁ</PRODUCTNAME>
    <DESCRIPTION>&lt;p&gt;Konvice s pokličkou smalt je vhodná ke každodennímu použití. Lze ji mýt v myčce na nádobí a je vhodná pro plynové, elektrické sporáky a indukci. Objem 2 l, v červené barvě s bílým puntíkem.&lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt; &lt;/p&gt;</DESCRIPTION>
    <URL>https://b2b.utc.cz/lahev-na-vodu-bisfree-eco-550ml-hneda/347058p/</URL>
    <IMGURL>https://b2b.utc.cz/bin/product/4/ABF644B.jpg</IMGURL>
    <IMGURL_ALTERNATIVE></IMGURL_ALTERNATIVE>
    <ORIGINAL_PRICE_VAT>199.00</ORIGINAL_PRICE_VAT>
    <PURCHASE_PRICE_VAT>164.46</PURCHASE_PRICE_VAT>
    <MANUFACTURER>LOCKNLOCK</MANUFACTURER>
    <CATEGORY>STOLOVÁNÍ | PŘÍPRAVA NÁPOJŮ | SPORTOVNÍ LAHVE</CATEGORY>
    <EAN>8803733138772</EAN>
    <ITEMGROUP_ID></ITEMGROUP_ID>
    <PRICE_VAT>199.00</PRICE_VAT>
</SHOPITEM>

如何引用 XML 标签内包含的特殊字符？

答案1

相关内容