Visual Studio Code using Regular expression to replace text with new line

Question

Hi I got about a 1000 lines of data, what I need to do is using regular expression mode on visual code to find "),(" and replace with a new line after the comment. Is this possible, below is an example of what im trying to achieve.

(test, null, null, 1),(test1, null, null, 2)

into

(test, null, null, 1),
(test1, null, null, 2)

Do you even need regex for that? Would have thought the bog-standard find/replace should just find ),( without issue — James Thorpe
– James Thorpe, Commented Feb 21, 2017 at 12:17
Sorry, yes - was forgetting you needed that mode turned on to do more complex replace statements - was concentrating on the find part :) — James Thorpe
– James Thorpe, Commented Feb 21, 2017 at 12:24

Adrian Dymorz · Accepted Answer · 2019-10-10 07:51:40Z

6

Search:

\([^\)]*\),

$, $ and , are literals

[^\)]* matches all characters which are not an )

Replace:

$0\n

$0 is the back reference for the whole match

$x (e.g. $1) would be the back reference for a group marked by ( and ), but is not required here as kennytm pointed out

\n is a newline

edited Oct 10, 2019 at 7:51

answered Feb 21, 2017 at 14:15

Adrian Dymorz

1,0079 silver badges29 bronze badges

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

1 Comment

kennytm Over a year ago

You could use $0 to refer to the whole match, thus no need to add the capturing group (…).

Collectives™ on Stack Overflow

Visual Studio Code using Regular expression to replace text with new line

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related