How to replace text at a special place in special rows?

[Terry R]

@Ekopalypse said in How to replace text at a special place in special rows?:

$122 wouldn’t work

From the little I have read I would think the \ means take “as few numbers following as possible”, whereas the $ might be "more greedy, sort of like the * and + quantifiers within regex. I think it did see that we can also use ( and ) to force the system to recognise what we actually want.

This might be another case of becoming a bit more particular such as the (?-s) which I admit is still something I HAVE to think about, otherwise I forget. Especially as I know my own environment and rarely use it “at home”.

Perhaps @guy038 can supply the “answer”?

Terry

[PeterJones]

@Terry-R , @Ekopalypse , and all interested parties:

From my understanding (as reflected in the Searching: capture groups and backreferences and substitutions docs), the \ℕ notation only accepts single-digit. In the search string, you can use one of the more verbose backreferences (\gℕ, \g{ℕ}, \g<ℕ>, \g'ℕ', \kℕ, \k{ℕ}, \k<ℕ> or \k'ℕ').

The Boost 1.70 docs confirm: back references says that in the \ℕ form, ℕ must be in the range 1-9; the \g-variants (especially with \g{ℕ} allow for higher ℕ values (the \k-variants are supposed to be for named groups, but they also work for numbered groups at last experimentation). The Boost replacement: placeholder sequences only mentions $ℕ and ${ℕ}, and do not mention \ℕ-notation at all in the substitution/replacement syntax.

My rule of thumb is to exclusively use $ℕ or ${ℕ} in replacements, and I use the ${ℕ} more often, because it is 100% unambiguous for reading (even though it is harder to type on my keyboard).

[Alan Kilborn]

I’m fairly certain it works like this:

\122 --> group 1 and then a literal 22

$122 --> group 12 and then a literal 2

${122} --> group 122

Obviously, the group numbers need to exist for it to work.

The good habit to get into is to always use the curly brace syntax, so, for example from the current discussion: ${1}22

[Ekopalypse]

@Alan-Kilborn said in How to replace text at a special place in special rows?:

I’m fairly certain it works like this:

I don’t think so.
Having the text

0123456789ABCDEF

and doing
find what:(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)
replace with:$122
doesn’t result in B2
but
replace with:$12 2
results in B 2

[Ekopalypse]

what we could do in addition is
replace with:($12)2

[Ekopalypse]

I can’t seem to get the \g notation to work either.
replace with:\g{12}2
results in g{12}2

[PeterJones]

@Ekopalypse said in How to replace text at a special place in special rows?:

what we could do in addition is
replace with:($12)2

Equivalently: replace with: ${12}2

I can’t seem to get the \g notation to work either.
replace with:\g{12}2

In Boost, \g-notation is only listed in the SEARCH section, not in the REPLACE section (fixed typo).

[PeterJones]

@Ekopalypse said in How to replace text at a special place in special rows?:

\g notation

To confirm: I can successfully search 0123456789ABCDEFB using the regex (.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)(.)\g12, and it matches (because the 17th character matches the 12th backref)

[Alan Kilborn]

@Ekopalypse

Haha, well, that’s why I said “fairly” certain.

Actually, I cheated: Long ago I read about RegexBuddy here on the Community (at least I think it was here), and purchased a license. It has proved invaluable.

Here’s what it told me for this case:

I should have cited RB a few minutes ago when I posted, but I wanted to see if there was agreement/disagreement first.

Very rarely have I found any discrepancies between RB and N++, but this may be one of those cases.

It is interesting that RB doesn’t say “Insert the character string 22 literally” in the second and third lines of its output, but breaks it into 2 parts…hmmm…

[Ekopalypse]

@Alan-Kilborn

maybe that is implementation detail (!?)

[ErwinSchmidt17]

Thank you for all your answers.

[guy038]

Hello, @ErwinSchmidt17, @terry-r, @ekopalypse, @peterjones, @alan-kilborn and All,

Sorry, to be late as I’m on a family vacation right now, for the better part of August ;-))

---

Quickly, about solutions to @ErwinSchmidt17’s problem, I would say :

SEARCH (?-s)(^.+projectID:1234.+pf2|\G).*?\K11(?=.*pf3)

REPLACE 22

Thus, the test data, below, containing 4 names 11.png, in the pf2 section :

{name:11.png,filename:c:\img\11\11.png,projectID:1234},pf1:{spname:11.png,spfilename:11.png},pf2:{spname:11.png,spfilename:11.png,bla_blah:11.png,test:11.png},pf3:{spname:11.png,spfilename:11.png},pf4:{...}

would be changed as :

{name:11.png,filename:c:\img\11\11.png,projectID:1234},pf1:{spname:11.png,spfilename:11.png},pf2:{spname:22.png,spfilename:22.png,bla_blah:22.png,test:22.png},pf3:{spname:11.png,spfilename:11.png},pf4:{...}

---

Now, about the different syntaxes, related to groups, back-references and subroutine calls, I did some tests and here are my conclusions, not definitive, of course :

In search regexes, the possible syntaxes, with Boost regex library, are :

• Unnamed group is defined with surrounding parentheses : (.....)

• Named group is defined with the one of the syntaxes :

  • (?<Name>.....)

  • (?'Name'.....)

• Absolute back-reference, to an unnamed group N, is defined with one of the syntaxes :

  • \N    ( with 1 <= N <= 9 )

  • \gN    \g{N}    \g<N>    \g'N'    ( with 1 <= N <= Max )

  • \kN    \k{N}    \k<N>    \k'N'    ( with 1 <= N <= Max )

• Relative back-reference, to an unnamed group X, is defined with one of the syntaxes :

  • \g-X    \g{-X}    \g<-X>    \g'-X'    ( with 1 < X <= Max )

  • \k-X    \k{-X}    \k<-X>    \k'-X'    ( with 1 < X <= Max )

• Absolute subroutine call, to an unnamed group N, is defined with the syntax :

  • (?N)    ( with 0 <= N < Max )

• Relative subroutine call, to an unnamed group of relative number X, is defined with one of the syntaxes :

  • (?-X)    ( with 1 < X <= Max )

  • (?+X)    ( with 1 < X <= Max )

• Absolute back-reference, to a named group Name, is defined with one of the syntaxes :

  • \g{Name}    \g<Name>    \g'Name'

  • \k{Name}    \k<Name>    \k'Name'

• Absolute subroutine call, to a named group Name, is defined with one of the syntaxes :

  • (?&Nom)

  • (?P>Nom)

---

Remarks :

• For all the relative syntaxes above, the Max value is the greatest group of the overall regex

• For all the absolute syntaxes, I suppose that the Max value is 2,147,483,647, as it’s the same value in replacement, too !

• The names of named groups are word characters, non beginning with a digit

• The (?0) is a subroutine call to the overall regex and is, implicitly, a recursive subroutine call !

Summary example :

To find a four-letters word palindrome, you can use, either, one of these 23 syntaxes :

\b(\w)(\w)\2\1\b

\b(\w)(\w)\g2\g1\b
\b(\w)(\w)\g{2}\g{1}\b
\b(\w)(\w)\g<2>\g<1>\b
\b(\w)(\w)\g'2'\g'1'\b

\b(\w)(\w)\k2\k1\b
\b(\w)(\w)\k{2}\k{1}\b
\b(\w)(\w)\k<2>\k<1>\b
\b(\w)(\w)\k'2'\k'1'\b

\b(\w)(\w)\g-1\g-2\b
\b(\w)(\w)\g{-1}\g{-2}\b
\b(\w)(\w)\g<-1>\g<-2>\b
\b(\w)(\w)\g'-1'\g'-2'\b

\b(\w)(\w)\k-1\k-2\b
\b(\w)(\w)\k{-1}\k{-2}\b
\b(\w)(\w)\k<-1>\k<-2>\b
\b(\w)(\w)\k'-1'\k'-2'\b

\b(?<First>\w)(?'Second'\w)\g{Second}\g{First}\b
\b(?<First>\w)(?'Second'\w)\g<Second>\g<First>\b
\b(?<First>\w)(?'Second'\w)\g'Second'\g'First'\b

\b(?'First'\w)(?<Second>\w)\k{Second}\k{First}\b
\b(?'First'\w)(?<Second>\w)\k<Second>\k<First>\b
\b(?'First'\w)(?<Second>\w)\k'Second'\k'First'\b

Test them against this text :

adda – a type of lizard
Adda – a river in Italy; a river in Wales
Anna – a girl’s name
Beeb – an informal name for the BBC
boob – a blunder; a breast
deed – various common meanings
goog – an egg (Australian slang)
immi – a Swiss unit of volume
keek – to peep
kook – a crazy person
naan – a type of Indian bread
noon – midday
Otto - a proper name
peep – various common meanings
poop – a raised deck at the stern of a ship; various other meanings
toot – the sound made by a horn or whistle

Now, as a subroutine call is, basically, a reference to the regex itself, included in a group and NOT the last value of this group like in back-references, the 5 following syntaxes are strictly equivalent to the simple regex \b\w{4}\b and looks for a four-letters word :

\b(\w)(\w)(?2)(?1)\b
\b(\w)(\w)(?-1)(?-2)\b
\b(?+2)(?+1)(\w)(\w)\b

\b(?<First>\w)(?'Second'\w)(?&Second)(?&First)\b
\b(?'First'\w)(?<Second>\w)(?P>Second)(?P>First)\b

Test them, again, on the same sample text, above !

Important :

• All the syntaxes, above, are valid in search part ONLY !

• Because of the multiple equivalent syntaxes, for groups, back-references and subroutine calls, it is useful to define, for search regexes, a single, minimal syntax, covering the majority of cases :

Hence, the table, below, with my preferences :

    •============================•=============================•===================•====================•
    |           GROUP            |          REFERENCE          |  ABSOLUTE number  |  RELATIVE number   |
    •============================•=============================•===================•====================•
    |                            |       BACK-REFERENCE        |  \N   or   \g{N}  |       \g{-X}       |
    |  (.....)          UNNAMED  |                             |                   |                    |
    |                            |       SUBROUTINE CALL       |       (?N)        |  (?-X)  or  (?-X)  |
    •----------------------------•-----------------------------•-------------------•--------------------•
    |                            |       BACK-REFERENCE        |     \g<Name>      |        N/A         |
    |  (?<Name>.....)     NAMED  |                             |                   |                    |
    |                            |       SUBROUTINE CALL       |     (?&Name)      |        N/A         |
    •============================•=============================•===================•====================•

---

In replacement regexes, , with Boost regex library, you can use the following syntaxes :

• Absolute reference, to an unnamed group N, is defined with either :

  • \N    ( with 1 <= N <= 9 )

  • $N    ( with 0 <= N <= 2,147,483,647 )

  • ${N}    ( with 0 <= N <= 2,147,483,647 )

• Absolute reference, to an named group Name, is defined with the syntax :

  • $+{Name}

Remarks :

• The $0 or $& syntaxes refer to the overall regex, itself

• If number N is superior to the number of back-references, in the search regex, these syntaxes return an empty string

• If a named reference $+{name} does not exist in search regex, it also returns an empty string

• If, in the replacement regex, a digit follows a $N syntax, it’s preferable to use the ${N} form !

• The $00...00N and ${00...00N} syntaxes are equivalent to, respectively, the $N and ${N} syntaxes

• So, the single minimal syntaxes, in replacement, seems to be :

    •============================•==================•===================•
    |           GROUP            |     REFERENCE    |  ABSOLUTE number  |
    •============================•==================•===================•
    |  (.....)          UNNAMED  |  BACK-REFERENCE  |       ${N}        |
    •----------------------------•------------------•-------------------•
    |  (?<Name>.....)     NAMED  |  BACK-REFERENCE  |     $+{Name}      |
    •============================•==================•===================•

Best Regards,

guy038

[guy038]

Hi, All,

Out of curiosity, do you know how I could determine that the maximum number of group is 2,147,483,647 ?

Well, I began the test using this simple regex S/R :

SEARCH (?-s).

REPLACE --${300}--

When replacing a single character, it returns the string ----. So, the S/R seemed valid and, as the group 300 did not exist, it just wrote the empty string as replacement of this group.

Then, I, successively, changed the replacement zone with :

• --${3000}--    =>    ----

• --${30000}--    =>    ----

• --${3000000000}--    =>    --$3000000000}--

As I suspected that the limit should have a relation to powers of 2, I searched for the largest power of 2, below 3,000,000, which is 2^31 = 2,147,483,647 !

Indeed :

SEARCH (?-s).

REPLACE --${2147483647}--

=> The ---- output

and :

SEARCH (?-s).

REPLACE --${2147483648}--

=> The --${2147483648}-- output

Of course, I do understand that this limit is quite theoretical ! Just imagine a regex containing 2,147,483,647 different groups… Brrrrr

Best Regards,

guy038

[Ekopalypse]

@guy038 - sounds like a 32bit integer limitation.

[Alan Kilborn]

@Ekopalypse

sounds like a 32bit integer limitation.

Or an implementation detail. ;-)
BTW, trying this in RegexBuddy, it reports “group 2147483647” but if you go one higher it reports “group -2147483648”.

[Ekopalypse]

@Alan-Kilborn

:-D

[Makwana Prahlad]

Hello,@ErwinSchmidt17

Follow this step,To How to replace text at a special place in special rows?

Step 1: Press Ctrl+H to bring up the Find/Replace Dialog.
Step 2: Choose the Regular expression option near the bottom of the dialog.

To add a word, such as test, at the beginning of each line:
Step 1: Type ^ in the Find what textbox
Step 2: Type test in the Replace with textbox
Step 3: Place cursor in the first line of the file to ensure all lines are affected
Step 4: Click Replace All button

To add a word, such as test, at the end of each line:
Step 1: Type $ in the Find what textbox
Step 2: Type test in the Replace with textbox
Step 3: Place cursor in the first line of the file to ensure all lines are affected
Step 4: Click Replace All button

I hope this information will be useful.
Thank you.

[Alan Kilborn]

@Makwana-Prahlad

How is that relevant?
You provided a solution for 2 things that were not even asked for.