Increment xml value in the next row in Notepad++

Question

I am looking to add elements to my XML document. A single element should be duplicated, while also incrementing its value - by using Notepad++.

Like below the <rateCode> element was duplicated incrementing values by 1:

<rateCode>1</rateCode>
<rateCode>2</rateCode>
<rateCode>3</rateCode>

and so on till 1000.

Is there any way to achieve this in Notepad++ ?

you can do it via excel and copy it to required place. using SEQUENCE(1000) for number in excel — karthik akinapelli, Aug 17 '21 at 07:10
Does this answer your question? [Notepad++ add number in each line](https://stackoverflow.com/questions/26178151/notepad-add-number-in-each-line) — AdrianHHH, Aug 17 '21 at 07:41

score 1 · Answer 1 · 2021-08-17T07:31:13.030

1

Alternative:

In Notepad++, use 'Search | Replace` regex:

Find what: ^(\d+)$ Replace with: <rateCode>\1</rateCode> Replace All

edited Aug 17 '21 at 07:31

answered Aug 17 '21 at 07:25

That's a KISS (keep it simple stupid) approach. Would prefer this to generate simple files from scratch. It basically generates a number of specified rows, which are then enhanced with static content - where simple must apply to the static content (the regex-replacement). – hc_dev Aug 17 '21 at 07:31

score 0 · Answer 2 · answered Aug 17 '21 at 07:20

You could use a macro in Notepad++ to achieve this autofilling.

# append a new XML element with incremented value
for i in range(1, 1000):
     editor.appendText("<rateCode>{}</rateCode>\r\n".format(i));

When new to Python programming get a brief introduction to implementing loops in Python, e.g. For Loop

2 Answers2