Hi, @moe-skaato, @alan-kilborn, @terry-r and All,
Of course, the fact of inserting letters, only at a specific column could be binding :-(( So, here is a new method, not based on columns ;-))
Assuming your text, in a new tab :
preset1= “description about preset” preset2= “description about preset” preset3= “description about preset” preset4= “description about preset” preset5= “description about preset” preset6= “description about preset” preset7= “description about preset” preset8= “description about preset” preset9= “description about preset” preset10= “description about preset” preset11= “description about preset” preset12= “description about preset”Now, just append your list of letters, at the end of your text, with one letter per line ! Of course, you need to insert, at least, the 12 first letters, but you may list, for instance, all letters from A to Z
Let’s add letters from A to P. So we get the text :
preset1= “description about preset” preset2= “description about preset” preset3= “description about preset” preset4= “description about preset” preset5= “description about preset” preset6= “description about preset” preset7= “description about preset” preset8= “description about preset” preset9= “description about preset” preset10= “description about preset” preset11= “description about preset” preset12= “description about preset” A B C D E F G H I J K L M N O PNow, using the regex S/R :
SEARCH (?-s)^(preset)(\d+)(?=(?:.+\R){12}(.))|^(.\R)+.?\Z
REPLACE ?1\1\3
You should get, after a click on the Replace All button :
presetA= “description about preset” presetB= “description about preset” presetC= “description about preset” presetD= “description about preset” presetE= “description about preset” presetF= “description about preset” presetG= “description about preset” presetH= “description about preset” presetI= “description about preset” presetJ= “description about preset” presetK= “description about preset” presetL= “description about preset”And if you change the Replace regex with :
REPLACE ?1\1\2\3While keeping the Search regex, you’ll obtain :
preset1A= “description about preset” preset2B= “description about preset” preset3C= “description about preset” preset4D= “description about preset” preset5E= “description about preset” preset6F= “description about preset” preset7G= “description about preset” preset8H= “description about preset” preset9I= “description about preset” preset10J= “description about preset” preset11K= “description about preset” preset12L= “description about preset”Of course, you can choose any list of letters, in any order and, also, the leading part of each line :
For instance, giving the initial text below :
preset1= “description about preset” preset2= “description about preset” preset3= “description about preset” preset4= “description about preset” preset5= “description about preset” preset6= “description about preset” preset7= “description about preset” preset8= “description about preset” preset9= “description about preset” preset10= “description about preset” preset11= “description about preset” preset12= “description about preset” z a y b x c w d v e u f t g s h r i q jWith the Replace regex, below ( Again, Search regex is not modified )
REPLACE ?1Line #\2\3\tHere is the result :
Line #1z = “description about preset” Line #2a = “description about preset” Line #3y = “description about preset” Line #4b = “description about preset” Line #5x = “description about preset” Line #6c = “description about preset” Line #7w = “description about preset” Line #8d = “description about preset” Line #9v = “description about preset” Line #10e = “description about preset” Line #11u = “description about preset” Line #12f = “description about preset”As you can see, the limit is just your imagination. With regular expressions, you can modify text in so many ways ;-))
Notes :
The search regex begins with (?-s), an in-line modifier, which tells that the dot ( . ) will match one standard character ( not EOL ones )
Then there are two alternatives :
^(preset)(\d+)(?=(?:.+\R){12}(.))
^(.\R)+.?\Z
The first alternative matches, from beginning of line ( ^ ) , the literal sting preset, stored as group 1, followed with a number \d+, stored as group 2 but ONLY IF the look-ahead is true that is to say if it exists 12 non-empty lines, with their EOL characters ( \R ), followed with, at least, one character ( a letter) on the next line, stored as group 3
Of course, in case that your text to re-number contains more or less than 12 lines, just indicate that exact number in the search regex, instead of the number 12 !
The second alternative simply matches the complete list of letters, at the end of your document. So a non-empty list of one-char lines ^(.\R)+, possibly followed with a last char ( .? ) before some possible EOL chars, ending the current file ( assertion \Z )
The replacement regex, for instance ?1Line #\2\3\t, is a conditional replacement, which means that, IF group 1 exists, then it writes, first, the expression Line #, followed with the initial numbers ( group 2 ), followed with the character, taken from the list of letters ( group 3 ) and, finally, a tabulation char ( \t )
Best Regards,
guy038
