REGEX doesn't match string if substring has already been matched

Question

Input Text -

hey, G Suite , ,Social Media Wall, Social Media Wall , ERP ERP Corecon

Query -

((?<=[,-./\s])(ERP Corecon|Social Media|Social Media Wall|ROI|ERP)\b)

Output -

hey, G Suite , ,**Social Media** Wall, **Social Media** Wall , **ERP** **ERP Corecon**

Ideal Output - Social Media & Social Media Wall both should be matched

regex link - https://regexr.com/6ugr5

Put the longer match before the shorter one in the query, like you did with ERP Corecon and ERP? — Joachim Isaksson
– Joachim Isaksson, Commented Sep 21, 2022 at 17:03
@JoachimIsaksson yes that can be done, but my regex pattern is auto-generated and I don't have control over that. Instead, I would prefer a regex pattern that can accommodate this. Also, I am trying to understand the reason why is Social Media Wall not being matched — Tushar Laad
– Tushar Laad, Commented Sep 21, 2022 at 17:04
When there are multiple matching alternatives, the result depends on the regexp engine. Some always prefer the longer match, some prefer the first match in the alternatives. I don't think there's a way to force one to act like the other. — Barmar
– Barmar, Commented Sep 21, 2022 at 17:08
@anubhava added input text to question - hey, G Suite , ,Social Media Wall, Social Media Wall , ERP ERP Corecon — Tushar Laad
– Tushar Laad, Commented Sep 21, 2022 at 17:17

anubhava · Accepted Answer · 2022-09-21 17:25:41Z

1

You may be able to use this regex:

(?<=[,-./\s])(ERP(?: Corecon)?|Social Media(?: Wall)?|ROI)\b

RegEx Demo

RegEx Breakup:

(?<=[,-./\s]): Lookbehind to assert presence of these chars before current position
(; Start capture group
- ERP(?: Corecon)?: Match ERP or ERP Corecon
- |: OR
- Social Media(?: Wall)?: Match Social Media or Social Media Wall
- |: OR
- ROI: Match ROI
): End capture group
\b: Word boundary

answered Sep 21, 2022 at 17:25

anubhava

790k67 gold badges603 silver badges671 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ricardo Valente · Accepted Answer · 2022-09-21 20:25:18Z

0

You could try to use named groups:

(?<SocialMediaWall>(?<SocialMedia>Social Media)( Wall)?)|(?<ERPCore>(?<ERP>ERP)( Corecon)?)|(?<ROI>ROI)

As you can see, the SocialMedia group is nested inside the SocialMediaWall group. That's a way of getting both values.

answered Sep 21, 2022 at 20:25

Ricardo Valente

5911 gold badge11 silver badges15 bronze badges

Comments

Tushar Laad · Accepted Answer · 2023-03-09 02:55:25Z

0

All your solutions were intriguing but I end up sorting my regex query into descending where the longer keywords came first, thus never allowing a substring to come before a string. This solved my problem.

answered Mar 9, 2023 at 2:55

Tushar Laad

513 bronze badges

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

REGEX doesn't match string if substring has already been matched

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related