Using regex in notepad++ to reduce json objects

Question

I have a huge Json file containing objects of the form:

{ "country" : "UK",  "city" : "London"  }

I want to limit the number of instances for each "country". Can I do this using regex? I want to remove the whole block of object that contains "UK". I tried something like ^{.*"UK".*}, (starts with { contains "UK" ends with },) But this is wrong and I can't figure out the correct way. Any help would be appreciated.

Tim Biegeleisen · Accepted Answer · 2018-01-04 09:41:58Z

4

In general, you should not be using regex alone to handle JSON content, even less so if that JSON be nested. If your JSON is always single level as you wrote above, then the following pattern might work:

\{[^}]*"UK"[^}]*\}

Replace the above by nothing, and do the find/replace in regex mode.

Demo

edited Jan 4, 2018 at 9:41

answered Jan 4, 2018 at 9:38

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

1 Comment

user1340852 Over a year ago

Yes I was waiting for 8 minutes to pass, as it doesn't let me mark earlier!

Collectives™ on Stack Overflow

Using regex in notepad++ to reduce json objects

1 Answer 1

Demo

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