1) I start with this is as a text file:
'1019806-P20','44940','1019806-P20'
2) I use Find and Replace with Reg expressions:
FIND: ^ (beginning of line)
REPLACE: (with this string)
INSERT INTO TABLE (SEQUENCE_NO,PART_NO,MANU_NO,MANU_PART_NO,ROWVERSION) VALUES
('1',
3) how do I increment the '1' like below while I find and replace the string at
the beginning of the line:
INSERT INTO TABLE (SEQUENCE_NO,PART_NO,MANU_NO,MANU_PART_NO,ROWVERSION) VALUES
('1','1019806-P20','44940','1019806-P20',
INSERT INTO TABLE (SEQUENCE_NO,PART_NO,MANU_NO,MANU_PART_NO,ROWVERSION) VALUES
('2','1019806-P21','44940','1019806-P21',
INSERT INTO TABLE (SEQUENCE_NO,PART_NO,MANU_NO,MANU_PART_NO,ROWVERSION) VALUES
('3','1019806-P25','44940','1019806-P25',
INSERT INTO TABLE (SEQUENCE_NO,PART_NO,MANU_NO,MANU_PART_NO,ROWVERSION) VALUES
('4','1036069','00624','1036069',
and so on ...
this is a sequence number and needs to be incremented. How do I do this in
PSPad?
--
<http://forum.pspad.com/read.php?2,57395,57395>
PSPad freeware editor http://www.pspad.com
