PSPad UNICODE 4.5.0 (2173) beta English

Replace in RegEx not working? wrote:

> I'm looking for expression
> ^(\d){3}\t
>
> But $1 contains always only 1 - not whole 111 or 112 etc -
> using (\d){3}

You must enclose wholeexpression into brackets:
^(\d{3})\t

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}

Try (\d{3}) Now you get exactly 3 digits in $1. Your way will put the 3 digits in $1, $2 and $3.

Martin

Yea! You have right I just started to coding in C# but in PSPad it is faster

$1$2$3 not working in (\d){3} - I checked this before my post and this will be the best solution for me

RegEx: ^(\d){3}\t
Replacement: INSERT INTO [JobCategories] ([IDJobCategory],IDParentJobCategory],[Description]) VALUES ('$1$2$3','$1$2','

Results are:

INSERT INTO [JobCategories] ([IDJobCategory],[IDParentJobCategory],[Opis]) VALUES ('1','1','Some desc')

But should be

INSERT INTO [JobCategories] ([IDJobCategory],[IDParentJobCategory],[Opis]) VALUES ('112','11','Some desc')

^(\d){1}(\d){1}(\d){1}\t

It is solution ;)

Ok - thx anyway!

Kind regards from Poland
Mateusz www.Kierepka.pl ;)