在字符串中搜索模式并存储其值

searching a pattern in string and storing its values

本文关键字：存储 模式 字符串 搜索      更新时间：2023-09-26

我有这个字符串格式的xml。我想要获得名为"ColumnName"的属性。请帮我在数组中查找并返回它。波纹管是格式

<EntitySet Name="Department" VersionConflict="False"  xmlns:">
<StringAttribute Caption="Department Number" ColumnName="fdeptno" Description="dept no" IsPrimaryKeyMember="True" IsRequired="True" MaxLength="2" Name="fdeptno" RequiredAdherenceMessage="EMPTY_ACCT(Department Number)" />
<StringAttribute Caption="Description" ColumnName="fdeptdesc" Description="department" IsRequired="True" MaxLength="35" Name="fdeptdesc" RequiredAdherenceMessage="DESCR_EMPTY" />
<StringAttribute Caption="Holiday Pay Acct" ColumnName="fholaccno" ContentType="GeneralLedgerAccount" Description="holiday" IsRequired="True" MaxLength="25" Name="fholaccno" RequiredAdherenceMessage="HOLIDAY_PAY_ACC">
  <StringAttribute.Format>
    <MaskFormat Mask="AAAAA-AA" />
  </StringAttribute.Format>
  <PropertyReference EntityName="glmast" Filter="GLMAST.flinactive=0" Name="prdept_fholaccno" ObjectName="ChartofAccountsMaintenance" PropertyName="fcacctnum" UseIndexView="True" />
</StringAttribute>
<StringAttribute Caption="Other Pay Acct" ColumnName="fothaccno" ContentType="GeneralLedgerAccount" Description="other" IsRequired="True" MaxLength="25" Name="fothaccno" RequiredAdherenceMessage="OTHER_PAY_EMPTY">
  <StringAttribute.Format>
    <MaskFormat Mask="AAAAA-AA" />
  </StringAttribute.Format>
  <PropertyReference EntityName="glmast" Filter="GLMAST.flinactive=0" Name="prdept_fothaccno" ObjectName="ChartofAccountsMaintenance" PropertyName="fcacctnum" UseIndexView="True" />
</StringAttribute>
<StringAttribute Caption="Sick Pay Acct" ColumnName="fsickaccno" ContentType="GeneralLedgerAccount" Description="sick" IsRequired="True" MaxLength="25" Name="fsickaccno" RequiredAdherenceMessage="SICK_PAY_EMPTY">
  <StringAttribute.Format>
    <MaskFormat Mask="AAAAA-AA" />
  </StringAttribute.Format>
  <PropertyReference EntityName="glmast" Filter="GLMAST.flinactive=0" Name="prdept_fsickaccno" ObjectName="ChartofAccountsMaintenance" PropertyName="fcacctnum" UseIndexView="True" />
</StringAttribute>
<StringAttribute Caption="Vacation Pay Acct" ColumnName="fvacaccno" ContentType="GeneralLedgerAccount" Description="vacation" IsRequired="True" MaxLength="25" Name="fvacaccno" RequiredAdherenceMessage="VAC_PAY_ACCT_EMPTY">
  <StringAttribute.Format>
    <MaskFormat Mask="AAAAA-AA" />
  </StringAttribute.Format>
  <PropertyReference EntityName="glmast" Filter="GLMAST.flinactive=0" Name="prdept_fvacaccno" ObjectName="ChartofAccountsMaintenance" PropertyName="fcacctnum" UseIndexView="True" />
</StringAttribute>
<IntegerAttribute ColumnName="identity_column" Name="identity_column" />
<ByteArrayAttribute ColumnName="timestamp_column" Name="timestamp_column" Searchable="False" />
<StringAttribute Caption="facility" ColumnName="fac" Description="facility" MaxLength="20" Name="fac" />

一种方法是使用DOMParser解析字符串。然后，您可以循环浏览所有元素并检查属性。不过，我更喜欢使用querySelectorAll，因为生成的代码简洁有效：

var xmlDoc = (new DOMParser).parseFromString(xml_string, 'text/xml');
var elementsWithAttr = xmlDoc.querySelectorAll('[ColumnName]');
var values = [].map.call(elementsWithAttr, function(element) {
    return element.attributes.getNamedItem('ColumnName').nodeValue;
});

演示：http://jsfiddle.net/hm3Cn/（我已经接受了您的XML输入，通过删除第一行的xmlns:"并在末尾添加</EntitySet>使其有效）。

相关文章：