Regexp question...

[Andrew]

I am composing SQL from my perl code.
Using regexp to strip off ||','|| from the end of select query.
Using something like

$select =~ s/\|\|\'\,\'\|\|$//;

Not being regexp virtuoso, would like to ask if it possible to escape
group of characters instead of escaping each one, i.e. something like:

$select =~ s/\||','||$//;

Thanks,
Andrew

 

[Ala Qumsieh]

I am composing SQL from my perl code.
Using regexp to strip off ||','|| from the end of select query.
Using something like

$select =~ s/\|\|\'\,\'\|\|$//;

You don't need to escape single quotes or commas since they are not
special regexp characters.

Not being regexp virtuoso, would like to ask if it possible to escape
group of characters instead of escaping each one, i.e. something like:

$select =~ s/\||','||$//;

A quick glance into perlre gives you the answer:

$select =~ s/\Q||','||\E$//;

--Ala

 

[Gunnar Hjalmarsson]

A quick glance into perlre gives you the answer:

$select =~ s/\Q||','||\E$//;

Actually, *you* just gave the answer, Ala, without any need for the OP
to look in perldoc perlre. ;-) (To OP: It's a good idea to do so anyway.)

Two further comments:

- \E right before $ is apparently redundant.

- See also perldoc -f quotemeta.

 

[gnari]

- \E right before $ is apparently redundant.

apparently not

gnari

 

[Henry Law]

Highly insufficient parameters.

Andrew, a word of warning if you are new here. Purl Gurl doesn't have
a fine reputation for accuracy in this newsgroup. Do a bit of
Googling in the archives if you want more information, but for the
time being I recommend you don't adopt his/her/its advice without
checking it first.

Henry Law <>< Manchester, England

 

[Gunnar Hjalmarsson]

apparently not

Okay.. Guess "apparently" was a bad choice of word. ;-) New try:

- \E right before $ is redundant.

 

[gnari]

Okay.. Guess "apparently" was a bad choice of word. ;-) New try:

- \E right before $ is redundant.

you misunderstand. I was not commenting on your wording,
but on your meaning. I am saying you are wrong.
the \E is not redundant.

gnari

 

[Gunnar Hjalmarsson]

you misunderstand. I was not commenting on your wording, but on
your meaning. I am saying you are wrong. the \E is not redundant.

??

Aha, now I understand. Since $ is a pattern metacharacter, \E *is*
needed, or else the pattern would not match without the literal
character $ being included in the string.

My bad. I should know better than questioning an answer to a regex
question without tests.

Thanks, gnari! Sorry for any confusion my comment may have caused.

 

[Mark Clements]

Purl Gurl wrote:

My, you are quite the Queen's git.

is that a decimal git, or do we have moronity in town, tediously, and
yet again?