如何查找并替换xml文本中含有指定节点/元素/标记/标签的特定行里的部分字符串/内容

hmlstfqtl · 发表于 2017-4-11 08:46:34

如何搜索文本中指定范围内容并替换
搜索目录下 config.xml 文件内容并提取红字部分 <location>D:\OneDrive\MouseRecorder\Phraseexpress\phrases.pxp</location>然后把文本内所有的"D:\OneDrive\MouseRecorder\Phraseexpress\"替换为当前 config.xml 文件当前路径
替换的同时还要保持其他行的内容不变，比如说204,205,206这几行，比较特殊。

内容如下

<?xml version="1.0" encoding="utf-8"?>
<xml>
<pexconfig>
<PhraseFile>
<Data>
<phrases>
<min_ver>10.0.34</min_ver>
<version>4.0.21</version>
<lastused>
<description>最后使用</description>
<location>D:\OneDrive\MouseRecorder\Phraseexpress\lastused.pxp</location>
<cacheloaded>False</cacheloaded>
</lastused>
<clipboard>
<description>剪贴板缓存</description>
<location>D:\OneDrive\MouseRecorder\Phraseexpress\clipboard.pxp</location>
<cacheloaded>False</cacheloaded>
</clipboard>
<file>
<description>快捷用语</description>
<location>D:\OneDrive\MouseRecorder\Phraseexpress\phrases.pxp</location>
<cacheloaded>False</cacheloaded>
</file>
</phrases>
</Data>
<NP/>
<DoSyncFiles>-1</DoSyncFiles>
<PhrasesTouched>1</PhrasesTouched>
<ServerSwitched>0</ServerSwitched>
<DBT/>
<DBTS/>
<BackupCount>10</BackupCount>
<BackupPath>D:\OneDrive\MouseRecorder\Phraseexpress\</BackupPath>
<CacheSQLData>0</CacheSQLData>
<LastSaveTarget/>
<SaveHistoryPaths/>
</PhraseFile>
<Other>
<DateOfFirstUse10>42741,5829091898</DateOfFirstUse10>
<DateOfFirstUseHash10>BC05A0AB89AABB7FC82FD4250520C1D0</DateOfFirstUseHash10>
<PayOff>49,95</PayOff>
<PaidOff>0</PaidOff>
<Version>10.5.41</Version>
<IsPro>1</IsPro>
<IsOlPro>0</IsOlPro>
<Rdata10>44485233516735306658773041513D3D</Rdata10>
<RdataX10/>
<Commercial>0</Commercial>
<IsLocalPro>1</IsLocalPro>
</Other>
<AutoLearn>
<Active>0</Active>
<BigSentence>1</BigSentence>
<SmallSentence>1</SmallSentence>
<NumberSentence>0</NumberSentence>
<SpecSentence>0</SpecSentence>
<InsideWords>1</InsideWords>
<Precision>1</Precision>
<MaxSuggestCount>200</MaxSuggestCount>
<WordsVsSentences>2</WordsVsSentences>
<UsageVsLength>4</UsageVsLength>
<MaxLife>14</MaxLife>
<MaxSize>100000</MaxSize>
<DoNumbers>1</DoNumbers>
<IgnoreList/>
<SingleBlockList/>
<CompareDate>42785,2943869907</CompareDate>
<AutoPrecision>1</AutoPrecision>
<SingleContext>1</SingleContext>
<SuggestionLength>15</SuggestionLength>
<WordSuggestionLength>5</WordSuggestionLength>
<AllowedApps/>
<DeclinedApps/>
<PartExec>0</PartExec>
<BigPartExec>0</BigPartExec>
</AutoLearn>
<General>
<PopupDisplayMode>2</PopupDisplayMode>
<PopupPositionMode>0</PopupPositionMode>
<PopupFixedPositionX>0</PopupFixedPositionX>
<PopupFixedPositionY>0</PopupFixedPositionY>
<PopupMaxItems>0</PopupMaxItems>
<ClipCacheHK>3158</ClipCacheHK>
<LastUsedHK>0</LastUsedHK>
<AutoCorrectHK>0</AutoCorrectHK>
<SimpleMode>0</SimpleMode>
<AutoSkip>0</AutoSkip>
<DoStats>0</DoStats>
<LocalOnly>1</LocalOnly>
<IgnoreCaps>0</IgnoreCaps>
<DoSound0>0</DoSound0>
<SoundFile0/>
<DoSound1>0</DoSound1>
<SoundFile1/>
<DoSound2>0</DoSound2>
<SoundFile2/>
<DoSound3>0</DoSound3>
<SoundFile3/>
<DoSound4>0</DoSound4>
<SoundFile4/>
<NewPhraseShortcut>1603</NewPhraseShortcut>
<LastUsedShortcut>1605</LastUsedShortcut>
<OpenSetShortcut>3151</OpenSetShortcut>
<EnDisAppShortcut>3194</EnDisAppShortcut>
<TrayPopupShortcut>0</TrayPopupShortcut>
<QuickSearchShortcut>114</QuickSearchShortcut>
<CheckUpdates>0</CheckUpdates>
<NextUpdate>42748,9159329977</NextUpdate>
<SkipUpdateVer>0</SkipUpdateVer>
<ListenUDPPort>1036</ListenUDPPort>
<ServerUDPPort>1037</ServerUDPPort>
<DoProxy>2</DoProxy>
<ProxyServer/>
<ProxyPort>80</ProxyPort>
<ProxyUsername/>
<ProxyPassword/>
<LicenseServer/>
<SQLLicenseDatabase/>
<ExecKey>9</ExecKey>
<PopupModifier>0</PopupModifier>
<PopupShortcutType>1</PopupShortcutType>
<PopupSearchCount2>3</PopupSearchCount2>
<PopupSearchInline>1</PopupSearchInline>
<PopupSearchInlineExt>1</PopupSearchInlineExt>
<PopupSearchCase>0</PopupSearchCase>
<PopupSearchRecurse>1</PopupSearchRecurse>
<PopupSearchMenuText>1</PopupSearchMenuText>
<PopupSearchExtended>1</PopupSearchExtended>
</General>
<ClipCache>
<PlainOnly>1</PlainOnly>
<TrimSpaces>0</TrimSpaces>
</ClipCache>
<AutoCorrect>
<MinLength>4</MinLength>
<MinCount>3</MinCount>
</AutoCorrect>
<LastText>
<MinLength>10</MinLength>
</LastText>
<Dialogs>
<ShowInsertDlg>0</ShowInsertDlg>
<ShowDeleteDlg>1</ShowDeleteDlg>
<ShowDatalossDlg>1</ShowDatalossDlg>
<ShowMacroErrorDlg>1</ShowMacroErrorDlg>
<ShowExpertDlg>0</ShowExpertDlg>
<ShowHotkeyCheckDlg>1</ShowHotkeyCheckDlg>
<ShowCharsNullDlg>1</ShowCharsNullDlg>
<ShowExtendedConfirmation>1</ShowExtendedConfirmation>
<ShowFunDlg>1</ShowFunDlg>
<ShowAppPhrase>1</ShowAppPhrase>
<ShowDetailsDlg>1</ShowDetailsDlg>
<ShowBadAutotextDlg>1</ShowBadAutotextDlg>
<ShowUpdateDialog>1</ShowUpdateDialog>
<ShowOptsChangeDlg>1</ShowOptsChangeDlg>
<ShowUSBDlg>0</ShowUSBDlg>
<ShowNoneDelimDlg>1</ShowNoneDelimDlg>
<ShowSearchInserts>1</ShowSearchInserts>
<ShowAsianCheck>1</ShowAsianCheck>
<ServerFoundCheck>1</ServerFoundCheck>
<ShowMultiEditDlg>1</ShowMultiEditDlg>
<FirstStart>0</FirstStart>
<ShowAllAppDlg>1</ShowAllAppDlg>
<ShowToolCloseDlg>0</ShowToolCloseDlg>
<ShowExportPassDlg>1</ShowExportPassDlg>
<ShowDropBoxFilesDlg>0</ShowDropBoxFilesDlg>
<ShowOpenDlg>1</ShowOpenDlg>
<ShowUpgExpireDlg>1</ShowUpgExpireDlg>
<ShowLicExpireDlg>1</ShowLicExpireDlg>
<ShowSavePosDlg>1</ShowSavePosDlg>
<ShowIcompatDlg>1</ShowIcompatDlg>
<ShowCancelDlg>1</ShowCancelDlg>
<ShowDelimBalloon>1</ShowDelimBalloon>
<ShowDDDlg>1</ShowDDDlg>
<ShowPhraseWiz>1</ShowPhraseWiz>
<ShowLastUsedBubble>1</ShowLastUsedBubble>
<ShowElevatedBubble>1</ShowElevatedBubble>
<NoWarnings>0</NoWarnings>
<MinOnClose>1</MinOnClose>
<CancelOnEscape>1</CancelOnEscape>
<DoImportWizard>0</DoImportWizard>
<Language>0</Language>
<FindDlgWidth>483</FindDlgWidth>
<FindDlgHeight>277</FindDlgHeight>
<InputDlgLeft>-2147483648</InputDlgLeft>
<InputDlgTop>-2147483648</InputDlgTop>
<FormularLeft>-2147483648</FormularLeft>
<FormularTop>-2147483648</FormularTop>
<InputOnTop>1</InputOnTop>
<FormOnTop>1</FormOnTop>
<ShowBubbles>0</ShowBubbles>
<LastOpenDlgRes>0</LastOpenDlgRes>
<CaretPositionMode>4</CaretPositionMode>
<CaretPositionX>-99999999</CaretPositionX>
<CaretPositionY>0</CaretPositionY>
<PrintPreviewWidth>0</PrintPreviewWidth>
<PrintPreviewHeight>0</PrintPreviewHeight>
<SearchHistory>FEJ0LlFZNAASPwEpL1VHEVxPGXx0OAU/CSY+SRoHIAYmDWRRFgUPYicJWlQ0NAI=</SearchHistory>
</Dialogs>
<Expert>
<AllowedApps/>
<DeclinedApps/>
<AppMethods/>
<CharsBefore>#0#10#9#13 "'<{([/\-_</CharsBefore>
<CharsAfter>#9#10#13 "'>}]).,?!/\:;-_ </CharsAfter>
<SentenceDelimiters>.;!?#9#13#10</SentenceDelimiters>
<GlobalPrefix/>
<MaxCharsAfterPopupEx>0</MaxCharsAfterPopupEx>
<PopupHideTime>3600</PopupHideTime>
<RndDelay>0</RndDelay>
<HotkeyCheck>1</HotkeyCheck>
<MaxDescLength>128</MaxDescLength>
<ClipboardBackup>1</ClipboardBackup>
<ForceFocus>1</ForceFocus>
<UseOldParser>0</UseOldParser>
<SaveMeta>1</SaveMeta>
<UseClbFrom>0</UseClbFrom>
<FocusDelay>200</FocusDelay>
<RestoreClbDelay>350</RestoreClbDelay>
<PlainClbDelay2>50</PlainClbDelay2>
<SimKeyDelay>90</SimKeyDelay>
<GlobalTiming>750</GlobalTiming>
<DoRouteEnter>0</DoRouteEnter>
<WatchClipboard>0</WatchClipboard>
<MinRefineLength>3</MinRefineLength>
<KeyByKeyPasteMethod>0</KeyByKeyPasteMethod>
<UTFMail>0</UTFMail>
<MailMode>1</MailMode>
<maxUnwantedChars>10</maxUnwantedChars>
<DoACC>0</DoACC>
<AutoCapsCount>2</AutoCapsCount>
<DoAutoCaps>0</DoAutoCaps>
<DocGenSeparator/>
</Expert>
<Popup>
<VistaStyle>1</VistaStyle>
<AutolearnColor>-16777212</AutolearnColor>
<AutolearnTextColor>-16777209</AutolearnTextColor>
<SelRectColor>14314496</SelRectColor>
<SelBackColor>16045234</SelBackColor>
<BackColor>15790320</BackColor>
<SeparatorColor>12632256</SeparatorColor>
<BorderColor>8421504</BorderColor>
<SearchColor>-16777211</SearchColor>
<QsColor>2322898</QsColor>
<PopupBackgroundColor>-16777212</PopupBackgroundColor>
<PopupHighlightColor>-16777187</PopupHighlightColor>
<PopupAutotextBackgroundColor>-16777212</PopupAutotextBackgroundColor>
<PopupAutotextHighlightColor>-16777187</PopupAutotextHighlightColor>
<PopupHotkeyBackgroundColor>-16777212</PopupHotkeyBackgroundColor>
<PopupHotkeyHighlightColor>-16777187</PopupHotkeyHighlightColor>
<PopupHotBackgroundColor>-16777212</PopupHotBackgroundColor>
<PopupHotHighlightColor>-16777187</PopupHotHighlightColor>
<PopupTextColor>-16777209</PopupTextColor>
<PopupTextColorSelected>-16777209</PopupTextColorSelected>
<PopupAutoTextColor>-16777209</PopupAutoTextColor>
<PopupAutoTextColorSelected>-16777209</PopupAutoTextColorSelected>
<PopupHotkeyTextColor>-16777209</PopupHotkeyTextColor>
<PopupHotkeyTextColorSelected>-16777209</PopupHotkeyTextColorSelected>
<PopupHotTextColor>-16777209</PopupHotTextColor>
<PopupHotTextColorSelected>-16777209</PopupHotTextColorSelected>
<PopupDelay>200</PopupDelay>
<HintDelay>200</HintDelay>
<MaxCaptionLength>96</MaxCaptionLength>
<PopupHintLength>1024</PopupHintLength>
<PopupShowHint>1</PopupShowHint>
<ShowInfo>0</ShowInfo>
<FilterTray>1</FilterTray>
<SortPopupMode>0</SortPopupMode>
<SortPopupCol>0</SortPopupCol>
<SortPopupDir>0</SortPopupDir>
<AlPopupShowDelay>200</AlPopupShowDelay>
<PopupFont>Microsoft YaHei UI|9|000</PopupFont>
</Popup>
<Edit>
<OldPlainView>0</OldPlainView>
<DoWrap>1</DoWrap>
<DoGutter>0</DoGutter>
<DoSyn>1</DoSyn>
<DoRulers>0</DoRulers>
<DoShowSpecialChars>0</DoShowSpecialChars>
<OleFitMode>0</OleFitMode>
<LastFormat>0</LastFormat>
<LastDDAct>-1</LastDDAct>
<DoLastUsedFormat>0</DoLastUsedFormat>
<ShowDetails>1</ShowDetails>
<LastNewPhraseFocus>0</LastNewPhraseFocus>
</Edit>
<MainWindow>
<Left>2039</Left>
<Top>89</Top>
<Width>940</Width>
<Height>725</Height>
<MainSplitter>34,0425531914894</MainSplitter>
<TreeSplitter>0</TreeSplitter>
<MainSplitterWidth>320</MainSplitterWidth>
<TreeSplitterWidth>320</TreeSplitterWidth>
<Maximized>0</Maximized>
</MainWindow>
<UI>
<PhraseColVis0>1</PhraseColVis0>
<PhraseColWidth0>80</PhraseColWidth0>
<PhraseColPos0>0</PhraseColPos0>
<PhraseColVis1>1</PhraseColVis1>
<PhraseColWidth1>68</PhraseColWidth1>
<PhraseColPos1>1</PhraseColPos1>
<PhraseColVis2>1</PhraseColVis2>
<PhraseColWidth2>80</PhraseColWidth2>
<PhraseColPos2>2</PhraseColPos2>
<PhraseColVis3>1</PhraseColVis3>
<PhraseColWidth3>80</PhraseColWidth3>
<PhraseColPos3>3</PhraseColPos3>
<PhraseColVis4>1</PhraseColVis4>
<PhraseColWidth4>80</PhraseColWidth4>
<PhraseColPos4>4</PhraseColPos4>
<PhraseColVis5>1</PhraseColVis5>
<LockWidth1>0</LockWidth1>
<LockWidth2>0</LockWidth2>
<LockWidth3>0</LockWidth3>
<TreeViewMode>0</TreeViewMode>
<HideDemoFunctions>0</HideDemoFunctions>
<PlainFontSize>10</PlainFontSize>
<MakroOwnFormat>1</MakroOwnFormat>
<AccessRightsByOwnerOnly>0</AccessRightsByOwnerOnly>
<HideUsers>0</HideUsers>
</UI>
<Search>
<MinCharSearch>1</MinCharSearch>
<SearchThresold>100</SearchThresold>
<SearchWhere>1000</SearchWhere>
<SearchCase>0</SearchCase>
<SearchWhole>0</SearchWhole>
<SearchExact>0</SearchExact>
</Search>
<Statistics>
<StatsDate>42785,5212947801</StatsDate>
<TodayPhrases>0</TodayPhrases>
<TotalPhrases9>0</TotalPhrases9>
<TodayChars>0</TodayChars>
<TotalChars>0</TotalChars>
<UserSpeed>120</UserSpeed>
<UserLoan>10</UserLoan>
<Measured>0</Measured>
</Statistics>
<Hidden>
<DoNewBitmap>1</DoNewBitmap>
<MSAutoCorrectDisabled>0</MSAutoCorrectDisabled>
<oldVersion>0</oldVersion>
<SaveDictionary>1</SaveDictionary>
</Hidden>
<Network>
<ConnectTimeout>1000</ConnectTimeout>
<ReadTimeout>30000</ReadTimeout>
<WaitTimeout>1500</WaitTimeout>
<RetryRegister>5000</RetryRegister>
<RetryConnect>2000</RetryConnect>
<RetryPass>500</RetryPass>
<RetryPassCancel>5000</RetryPassCancel>
<SuspendTimeout>1500</SuspendTimeout>
<UdpTimeout>1500</UdpTimeout>
<WaitThreadsTerminate>1</WaitThreadsTerminate>
<SQLPingInterval>10000</SQLPingInterval>
<SQLLoginTimeout>10</SQLLoginTimeout>
</Network>
<Server>
<UserData/>
</Server>
</pexconfig>
</xml>

复制代码

nwm310 · 发表于 2017-4-12 12:40:16

回复 1# hmlstfqtl

PowerShell代碼

dir config.xml | %{
[xml]$xml = gc -Literal $_.FullName -enc UTF8
$a = $_.DirectoryName
select-xml "//location" $xml | %{
$_.node."#text" = "$(Join-Path $a 'phrases.pxp')"
}
$xml.save($a + '\config-New.xml' )
}

复制代码

hmlstfqtl · 发表于 2017-4-13 08:40:33

可以单纯用批处理实现吗因为目标的电脑不能执行powershell脚本

		自动登录	找回密码
密码			注册

[新手上路]批处理新手入门导读	[视频教程]批处理基础视频教程	[视频教程]VBS基础视频教程	[批处理精品]批处理版照片整理器
[批处理精品]纯批处理备份&还原驱动	[批处理精品]CMD命令50条不能说的秘密	[在线下载]第三方命令行工具	[在线帮助]VBScript / JScript 在线参考

[文本处理] 如何查找并替换xml文本中含有指定节点/元素/标记/标签的特定行里的部分字符串/内容

评分