<http://forum.pspad.com/read.php?f=6&i=3441&t=3336>
----------------------------------------------------------------
[b]
Ok I need to convert it to Inserts with some parent categories like this:
I'm looking for expression
^(\d){3}\t
And I'm replacing using this syntax
INSERT INTO [JobCategories] ([IDJobCategory],[IDParentJobCategory],[Opis])
VALUES ('$1',ReplaceWithParent$1
But $1 contains always only 1 - not whole 111 or 112 etc - using (\d){3}
[/b]
Try (\d{3}) Now you get exactly 3 digits in $1. Your way will put the 3
digits in $1, $2 and $3.
Martin
--
PSPad freeware editor http://www.pspad.com