I'm trying to insert a sequence number into a file consisting of lines containing SQL statements.
I have enabled POSIX style REs in TP 5.4 or 5.3.1.
The interesting part of my data is:
Code: Select all
(1234567, 123);Code: Select all
(1234567, <sequence number>, 123);Code: Select all
\(([0-9]*), ([0-9]*)\);Code: Select all
(\1, \i, \2);All of them invariably return:
Code: Select all
(1234567, 1, 123);
... (2345678, 1, 231);
... (3456789, 1, 231);
Thanks
Peter