Increase numbers in txt file

[Yuljup]

Hi,

I have an xml file I would like to edit.

The function I'm looking for is to increase a number in the code... And I would like the number to increase by adding 1 every time the script runs.

For example:

--------------------------

<code in here: v="14">

   <some more code>

<end of code>

--------------------------

The number 14 should be 15 after the script is run... Then 16, and so on...

 

What I have so far:

$szFile = "C:\Service\Custom.xml"


$szText = FileRead($szFile,FileGetSize($szFile))
$szText = StringReplace($szText, "Something in here", "Something else in here")
FileDelete($szFile)
FileWrite($szFile,$szText)

Edited January 27, 2015 by Yuljup

[MikahS]

If you want to turn the 14 into a 15 or just add one each time it will make it easier on yourself to read the number from the file, then change it to an int and add 1 using:

Number()

[guinness]

Or

Int()

[Yuljup]

I'm sorry but I don't really understand. Could you please give me some examples?

[JohnOne]

Explain more.

What is the file type for start.

EDIT:

Never mind I see it's xml.

There is code in example forum to deal with xml files, with plenty of example.

EDIT2:

for example

'?do=embed' frameborder='0' data-embedContent>>

Edited January 27, 2015 by JohnOne

[MikahS]

I would check out the link JohnOne gave you, but here is a small example of something similar (untested):

Local $fileOpen, $fileRead, $findString, _
        $splitString, $num, $replacedString, _
        $szFile = "C:\Service\Custom.xml"

$fileOpen = FileOpen($szFile)
$fileRead = FileRead($fileOpen)

$findString = StringInStr($fileRead, 'v="')
$splitString = StringMid($fileRead, $findString + 2, 3) ; not taking into account 3 digit #'s such as 100, 200, etc

$num = Int($splitString)

$replacedString = StringReplace($fileRead, String($num - 1), String($num))

FileWrite($fileOpen, $replacedString)

FileClose($fileOpen)

Edited January 27, 2015 by MikahS

[jdelaney]

xmldom...the filecreate is just used to have the xml...you won't need that, or the filewrite.:

#include <File.au3>
$sFileText = "<code v=""14""><somemorecode /></code>"
_FileCreate("test.xml")
FileWrite("test.xml",$sFileText)
Local $oXML = ObjCreate("Microsoft.XMLDOM")
$oXML.load("test.xml")
$oV = $oXML.SelectSingleNode("//code/@v")
$oV.text = Int($oV.text) + 1
ConsoleWrite($oV.text & @CRLF)
$oXML.save("test.xml")
ConsoleWrite(FileRead("test.xml") & @CRLF)

output:

15
<code v="15"><somemorecode/></code>

Edited January 27, 2015 by jdelaney

[Yuljup]

Thanks for all your help, guys.

jdelaney: This is close to what I need. But how do I switch out the following part of your code with something that looks for any number, not just 14?

I would like the script to be run on an automated schedule, and not have to change the script every time.

 

$sFileText = "<code v=""14""><somemorecode /></code>"

 

[TheSaint]

$sFileText = "<code v=""14""><somemorecode /></code>"

Jdelaney's code doesn't look for that, it only used that in an example file.

The later code looks for whatever number is in the 'code v' section of your document.

Once you've run the code once, comment out the first 3 lines after the #include line, then run it again ... and again.

You should see that the number increments each time.

Or just try it with your xml file, after putting in the replacement path for "test.xml" for it.

The only possible issue, is if your number is not embedded in the same formatted text - <code v="

[Yuljup]

Brilliant! Thanks for clarifying this for me, TheSaints! And thank you again, jdelaney!

This is exactly what I needed.

If anyone is wondering or if anyone meets the same problem as I did;

This is to fix an issue where Enterprise Mode in IE11 stops working in a Citrix environment with Citrix User Profile Management.

I noticed that updating the xml file used by Enterprise Mode corrects the issue when it stops working.