Notepad incrementally replace

Question

Lets say I want to have a 10 rows of data but I want a value to increment for each row or piece of data  How do I increment that value   For example    If I have these rows  is there a regex way of replacing the id values to increment    lt row id  1    gt   lt row id  1    gt   lt row id  1    gt   lt row id  1    gt   lt row id  1    gt    --- Here is what I would like it to look like     if the first row s id goes up one thats ok    lt row id  1    gt   lt row id  2    gt   lt row id  3    gt   lt row id  4    gt   lt row id  5    gt

User · Answer

http   docs notepad-plus-plus org index php Inserting Variable Text  Notepad   comes equipped with a Edit -  Column  Alt C  Editor which can work on a rectangular selection in two different ways  Coledit png inserting some fixed text on every line including and following the current line  at the column of the insertion point  aka caret   Initially selected text is left untouched  As the picture illustrates  a linear series of numbers can be inserted in the same manner  The starting value and increment are to be provided  Left padding with zeroes is an option  and the number may be entered in base 2  8  10 or 16 - this is how the computed values will be displayed too  padding being based on the largest

User · Answer

Posting in case someone might have a use of it     I was looking for a solution for a problem a bit more sophisticated than OP - replacing EVERY occurrence of something with the number by same thing with incremented number    E g  Replacing something like this    lt row id  1    gt   lt row id  2    gt   lt row id  1    gt   lt row id  3    gt   lt row id  1    gt    By this    lt row id  2    gt   lt row id  3    gt   lt row id  2    gt   lt row id  4    gt   lt row id  2    gt    Couldnt find the solution online so I wrote my own script in groovy  a bit ugly but does the job             lt p gt  Finds words that matches template and increases them by 1         in word template represents number         lt p gt  E g  if template equals  Row       then     ALL Row 0 will be replaced by Row  1     All Row 1 will be replaced by Row  2      lt p gt  Warning - your find template might not work properly if   is the last character of it    etc      lt p gt  Requirments     - Original text does not contain tepmlate string    - Only numbers in non-disrupted sequence are incremented and replaced     i e  from example below  if Row 4 exists in original text  but Row 3 not  than Row 4 will NOT be     replaced by Row 5      def replace inc String text  int startingIndex  String findTemplate        assert findTemplate contains         search template needs to contain     placeholder      assert   findTemplate replaceFirst         contains          only one     placeholder is allowed      assert  text contains             input text should not contain           5 underscores       while  true            findString   findTemplate replace      startingIndex  toString            if   text contains findString   break          replaceString   findTemplate replace                 startingIndex  toString            text   text replaceAll findString  replaceString            return text replaceAll                get rid of         character       input findTemplate    Row      path    C  TEMP working copy txt  startingIndex   0     do stuff f   new File path  outText   replace inc f text startingIndex findTemplate  println  Results  n      outText f withWriter   out - gt  out println outText   println  Results written to  f

User · Answer

i had the same problem with more than 250 lines and here is how i did it   for example     lt row id  1    gt   lt row id  1    gt   lt row id  1    gt   lt row id  1    gt   lt row id  1    gt    you put the cursor just after the  1  and you click on alt   shift and start descending with down arrow until your reach the bottom line now you see a group of selections click on erase to erase the number 1 on each line simultaneously and go to Edit - gt  Column Editor and select Number to Insert then put 1 in initial number field and 1 in incremented by field and check zero numbers and click ok  Congratulations you did it

User · Answer

You can do it using Powershell through regex and foreach loop  if you store your values in file input txt    initialNum 1   increment 1   tmp   Get-Content input txt   foreach     n    regex   match     id    d      groups 1   value  if   n      -replace   n     int32  initialNum  increment    increment  increment 1   else           After that you can store  tmp in file using  tmp  gt  result txt  This doesn t need data to be in columns

User · Answer

Solutions suggested above will work only if data is aligned   See solution in the link using PythonScript Notepad   plugin  It Works great  stackoverflow Find Replace but Increment Value

User · Answer

Since there are limited real answers I ll share this workaround  For really simple cases like your example you do it backwards     From this  1 2 3 4 5   Replace  r n with     gt  r n lt row id   and you ll get 90  of the way there  1    gt   lt row id  2    gt   lt row id  3    gt   lt row id  4    gt   lt row id  5   Or is a similar fashion you can hack about data with excel spreadsheet  Just split your original data into columns and manipulate values as you require        lt row id         1           gt            lt row id         1           gt            lt row id         1           gt            lt row id         1           gt            lt row id         1           gt         Obvious stuff but it may help someone doing the odd one-off hack job to save a few key strokes

User · Answer

I was looking for the same feature today but couldn t do this in Notepad    However  we have TextPad to our rescue  It worked for me   In TextPad s replace dialog  turn on regex  then you could try replacing   lt row id  1   gt    by    lt row id   i   gt    Have a look at this link for further amazing replace features of TextPad - http   sublimetext userecho com topic 106519-generate-a-sequence-of-numbers-increment-replace

User · Answer

Not sure about regex  but there is a way for you to do this in Notepad    although it isn t very flexible    In the example that you gave  hold Alt and select the column of numbers that you wish to change  Then go to Edit- gt Column Editor and select the Number to Insert radio button in the window that appears  Then specify your initial number and increment  and hit OK  It should write out the incremented numbers   Note  this also works with the Multi-editing feature  selecting several locations while maintaining Ctrl key pressed    This is  however  not anywhere near the flexibility that most people would find useful  Notepad   is great  but if you want a truly powerful editor that can do things like this with ease  I d say use Vim

[regex] Notepad++ incrementally replace

Examples related to regex

Examples related to notepad++

Examples related to sequential