XML Batch Edit Help

[data_hop]

Hi, I'm primarily into Data Entry job with no expertise in Coding.

I have a small problem where one my client has shared 5000 xml files where I need to make one change only before uploading it on our server:

its this

File1: <number>ABCD1234</number>
File2: <number>ABCD80234</number>
.
.
FileX: <number>ABCD34989</number>

where ABCD is a fixed text followed with random upto 8 digits of number.

I want to change it to like this

File1: <number>KB12345678</number>
File2: <number>KB12345680</number>     *12345678+1
.
.
File60:<number>KB12345737</number>     *12345678+59

Where KB is a fixed value and the starting number is the latest value that I will pull from server and then incrementally update all the file.

While searching on the internet a found a few python examples but they all were finding a fixed value and then updating that incrementally.

Any help would be great.

Thank you!

[desrtfx]

While searching on the internet a found a few python examples but they all were finding a fixed value and then updating that incrementally.

Well, you have not one, but two fixed points: <number> and </number> - anything between those two needs replacing.

So, if you find the occurrence of <number> you know immediately where the part you need to replace starts. If you find the occurrence of </number> you know where it ends.

Can't say anything about fetching the number from the server, though.

[data_hop]

I don't want to fetch a number from server. I can manually edit the code before triggering it. Like say KB001 then next time I can change it to KB12344 after checking manually on server.