how to find comma matches containing a specific word?

user_10379438 0
Viewed 24

In this string :

GPN1 VRT Full competence (Tel),GPN1 VRT midle (Tel) ,GPN1 Open Mobile AC GNE (Tel),GPN1 VRT Best competence (Tel)

I would like to extract all the content between commas containing the word VRT.

I tried this regular expression : [\s\w]*VRT.*?(?=,).

It works on the first one but I can't repeat it so that it gets me all the others.

Could you, please, help me?

regex
1 Answers

You can use

[^,]*VRT[^,]*

See the regex demo. If the VRT must be matched as a whole word, add word boundaries:

[^,]*\bVRT\b[^,]*

See this regex demo. Details:

  • [^,]* - zero or more non-commas
  • \bVRT\b - VRT enclosed with word boundaries
  • [^,]* - zero or more non-commas.
user_38329700
Related