CODEWITHSUNDEEP
jsonregexsublimetext3sublimetext
ak2492
ak2492

Reputation: 315

Regex to replace spaces in quoted strings with _ (Sublime)

I am trying to modify keys in my JSON file (around 60 MB) by removing spaces if there are any. I use Sublime Text Editor to load and edit large JSONs.

Currently, I am using the following expression to find quoted strings with spaces:

"([a-zA-Z])+([\s])+([a-zA-Z]*)":

Finds: "First Name":

Then I use the following expression to replace space with underscore with the matched string:

"$1_$3":

Result: "t_Name":

Expected: "First_Name":

I am not able to figure out why I am not able to capture the first word with $1. Any help would be appreciated. Thanks!

Note: There are around 15000 different keys with spaces in the JSON.

Upvotes: 1

Views: 323

Answers (1)

Ryszard Czech
Ryszard Czech

Reputation: 18621

Use

"([a-zA-Z]+)\s+([a-zA-Z]*)":

See proof

Explanation

--------------------------------------------------------------------------------
  "                        '"'
--------------------------------------------------------------------------------
  (                        group and capture to \1:
--------------------------------------------------------------------------------
    [a-zA-Z]+                any character of: 'a' to 'z', 'A' to 'Z'
                             (1 or more times (matching the most
                             amount possible))
--------------------------------------------------------------------------------
  )                        end of \1
--------------------------------------------------------------------------------
  \s+                      whitespace (\n, \r, \t, \f, and " ") (1 or
                           more times (matching the most amount
                           possible))
--------------------------------------------------------------------------------
  (                        group and capture to \2:
--------------------------------------------------------------------------------
    [a-zA-Z]*                any character of: 'a' to 'z', 'A' to 'Z'
                             (0 or more times (matching the most
                             amount possible))
--------------------------------------------------------------------------------
  )                        end of \2
--------------------------------------------------------------------------------
  ":                       '":'

Upvotes: 2

Related Questions