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
P
Now, 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\3
While 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
j
With the Replace regex, below ( Again, Search regex is not modified )
REPLACE
?1Line #\2\3\t
Here 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
