Replace all besides the Regex group?

Question

I was given a task to do which requires a long time to do.

The image say it all :

This is what I have : (x100 times):

enter image description here

And I need to extract this value only

enter image description here

How can I capture the value ?

I have made it with this regex :

DbCommand.*?$"(.*?)"$;

As you can see it does work :

enter image description here

And after the replace function (replace to $1) I do get the pure value :

enter image description here

but the problem is that I need only the pure values and not the rest of the unmatched group :

Question : In other words :

How can I get the purified result like :

Eservices_Claims_Get_Pending_Claims_List
Eservices_Claims_Get_Pending_Claims_Step1

Here is my code at Online regexer

Is there any way of replacing "all besides the matched group" ?

p.s. I know there are other ways of doing it but I prefer a regex solution ( which will also help me to understand regex better)

RegexBuddy would do this...also running it through visual studio would give you what you want... Your link didn't work so I can't help much more than that. — abc123, Dec 09 '13 at 09:25
possible duplicate of [Invert match with regexp](http://stackoverflow.com/questions/957379/invert-match-with-regexp) — abc123, Dec 09 '13 at 09:30
@abc123 Visual studio regex search engine is far stupid than JS regex engine. FYI — Royi Namir, Dec 09 '13 at 09:31
@abc123 nice one. I've tried this :http://regexr.com?37ibc. but is there a way of getting the inner group only with the already used regex ? — Royi Namir, Dec 09 '13 at 09:35
That site doesn't work for me...i'm sorry if I can't help further... — abc123, Dec 09 '13 at 09:38

Tibos · Answer 1 · 2013-12-09T10:13:07.260

Unfortunately, JavaScript doesn't understand lookbehind. If it did, you could change your regular expression to match .*? preceded (lookbehind) by DbCommand.*?$" and followed (lookahead) by "$;.

With that solution denied, i believe the cleanest solution is to perform two matches:

// you probably want to build the regexps dynamically
var regexG = /DbCommand.*?\("(.*?)"\);/g;
var regex  = /DbCommand.*?\("(.*?)"\);/;
var matches = str.match(regexG).map(function(item){ return item.match(regex)[1] });

console.log(matches); 
// ["Eservices_Claims_Get_Pending_Claims_List", "Eservices_Claims_Get_Pending_Claims_Step1"]

DEMO: http://jsbin.com/aqaBobOP/2/edit

score 1 · Accepted Answer · answered Dec 09 '13 at 09:36

1

You should be able to do a global replace of:

public static DataTable.*?{.*?DbCommand.*?\("(.*?)"\);.*?}

All I've done is changed it to match the whole block including the function definition using a bunch of .*?s.

Note: Make sure your regex settings are such that the dot (.) matches all characters, including newlines.

In fact if you want to close up all whitespace, you can slap a \s* on the front and replace with $1\n:

\s*public static DataTable.*?{.*?DbCommand.*?\("(.*?)"\);.*?}

Using your test case: http://regexr.com?37ibi

answered Dec 09 '13 at 09:36

lc.

113,939
20
158
187

so it should be `[\s\S]` – Royi Namir Dec 09 '13 at 09:38
@RoyiNamir Sure, or use the "dotall" option (in JavaScript I believe this is the `s` flag) – lc. Dec 09 '13 at 09:41
My way of thinking is to the group and then exclude all beside it....(without searching the exclude) – Royi Namir Dec 09 '13 at 09:41
p.s. there is a checkbox dotall in the online tool – Royi Namir Dec 09 '13 at 09:41

score 1 · Answer 3 · answered Dec 09 '13 at 10:44

1

You can use this (without the ignore case and multiline option, with a global search):

pattern: (?:[^D]+|\BD|D(?!bCommand ))+|DbCommand [^"]+"([^"]+)
replace: $1\n

answered Dec 09 '13 at 10:44

Casimir et Hippolyte

88,009
5
94
125

JonM · Answer 4 · 2013-12-09T09:55:30.113

0

Try simply replacing the whole document replacing using this expression:

^(?: |\t)*(?:(?!DbCommand).)*$

You will then only be left with the lines that begin with the string DbCommand

You can then remove the spaces in between by replacing: \r?\n\s* with \n globally.

Here is an example of this working: http://regexr.com?37ic4

edited Dec 09 '13 at 09:55

answered Dec 09 '13 at 09:42

JonM

1,314
10
14

this will not yield purifed results. – Royi Namir Dec 09 '13 at 10:08

Replace all besides the Regex group?

4 Answers4