How to mass replace 'inner text' in specific keys in XML file? (1)
Download: 20111223.Profiling.XML.MassReplace as zip package
;==========================================================================================================================================
;
; How to mass replace 'inner text' in specific keys in XML file? (1)
;
; The 'StrIndexWild' Version.
;
; (c)Detlev Dalitz.20111216.
;==========================================================================================================================================

;-----------------------------------------------------
;   Ini file "Config.ini".
;
;   [IniFilePass]
;   C01_01=Pass
;   C01_02=Pass
;   C01_03=Pass
;   C01_04=Pass
;   D01_02=Pass
;   D01_03=Not Reporting
;   D01_04=Not Reporting
;   D01_05=Pass
;   E01_01=Pass
;   E01_02=Pass
;   E01_03=Confidential - Not Provided
;   E01_04=Pass
;   E01_05=Pass
;   E01_06=Pass
;   E01_07=Pass
;   E01_08=Not Reporting - Privileged Information
;   E01_09=Pass
;   E01_10=Pass
;-----------------------------------------------------

; Define working folder.
strFolderHome = DirScript ()
DirChange (strFolderHome)

; Define data file pathes.
strFileIni = strFolderHome : "Config.ini"
strFileXmlIn = strFolderHome : "Data.in.xml"
strFileXmlOut = strFolderHome : "Data.out.xml"

; For sure, remove existing output file.
If 0 != FileExist (strFileXmlOut) Then FileDelete (strFileXmlOut)


; Read input xml into string variable.
strXml = FileGet (strFileXmlIn)

; Open ini file and walk through the items.
strIniSection = "IniFilePass"
strListItems = IniItemizePvt (strIniSection, strFileIni)
intItems = ItemCount (strListItems, @TAB)
For intI = 1 To intItems
   strKey = ItemExtract (intI, strListItems, @TAB)
   strValue = IniReadPvt (strIniSection, strKey, "Pass", strFileIni)
   If strValue == "Pass" Then Continue

   strTagSearch = StrReplace ("<{1}>*</{1}>", "{1}", strKey)
   ;strTagReplace = StrReplace ("<{1}>### SECRET DATA ###</{1}>", "{1}", strKey) ; Adapt it to your needs, for example leave xml tag content empty.
   strTagReplace = StrReplace ("<{1}>" : strValue : "</{1}>", "{1}", strKey) ; Adapt it to your needs, for example fill it with the value from ini file.

   intPos = 1
   While @TRUE
      intPos = StrIndexWild (strXml, strTagSearch, intPos)
      If intPos == 0 Then Break
      intLen = StrLenWild (strXml, strTagSearch, intPos)
      strXml = StrSub (strXml, 1, intPos - 1) : strTagReplace : StrSub (strXml, intPos + intLen, -1)
      intPos = intPos + StrLen (strTagReplace)
   EndWhile
Next

; Write string variable to disk file.
intBytesWritten = FilePut (strFileXmlOut, strXml)

; If this script has been called from another WB script, then return to the caller from here ...
If RtStatus () != 10 Then If IntControl (77, 80, 0, 0, 0) > 0 Then Return ; ... when not in WinBatch Studio debug mode.

; Display result.
ShellExecute (strFileXmlOut, "", "", @NORMAL, "")

:CANCEL
Exit