XML 数据提取 [英] XML Data extraction

问题描述

<Filer>
<ID>123456789</ID>
<Name>
<BusinessNameLine1>Stackoverflow</BusinessNameLine1>
</Name>
<NameControl>stack</NameControl>
<USAddress>
<AddressLine1>123 CHERRY HILL LANE</AddressLine1>
<City>LA</City>
<State>CA</State>
<ZIPCode>90210</ZIPCode>
</USAddress>
</Filer>

这里有一个给我的 xml 代码示例.有了这个 xml，我需要从这个 xml 中掌握某个属性.

Here I have a sample of xml code given to me. With this xml I need to grasp a certain attribute from this xml.

我只需要从文件中提取所有 <BusinessNameLine1>.问题是这个标签在整个文件中出现多次，但我只需要在 <Filer> 标签中它为假时提取它.

I simply need to extract all the <BusinessNameLine1> from the file. The issue is that this tag appears multiple times through out the file but I only need to extract it if it false in the <Filer> Tag.

我会使用 PHP 执行此操作，但我正在工作，由于无法在我的计算机上安装软件，我无法运行 php 代码.但是，我可以执行 bash 文件.该文件也非常大，所以我不能把它放在excel中.我不知道该怎么做.我将不胜感激有关从哪里开始的帮助或指导.

I would do this with PHP but I am at work and I am not able to run php code due to not being able to install software on my computer. I can execute bash files however. The file is also extremely large so I can not put it in excel. I have no idea how to do this. I would appreciate some help or guidance on where to start.

推荐答案

你可以试试这个组合的 awk 和 sed 命令，

You could try this combined awk and sed commands,

$ awk -v RS='</Filer>' '/^<Filer>/ {gsub (/
/," "); print}' file | sed -r 's/.*<BusinessNameLine1>([^<]*)</BusinessNameLine1>.*/1/g'
Stackoverflow

这篇关于XML 数据提取的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！