Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Json – Regex pattern to select boundary words excluding words inside double quotes

I give up! I have tried so many different things here and what little hair I have left Im losing so if someone could help me out Id be most grateful.

I have some badly formed Json:

friend_in_need: {
    id: 3
    
    possible: {
        is_ironman: yes
        difficulty: {">": 1}
        has_start_date: {"<": "1936-01-02"}
        has_any_custom_difficulty_setting: no
        game_rules_allow_achievements: yes
    }
    
    happened: {
        has_country_flag: "achievement has joined faction"
    }
}

… that I am trying to clean up in various steps using Regex replacement statements.

The step I am trying to do next is to match each key and string values so that I append double quotes around them, like the following:

"friend_in_need": {
    "id": 3
    
    "possible": {
        "is_ironman": "yes"
        "difficulty": {">": 1}
        "has_start_date": {"<": "1936-01-02"}
        "has_any_custom_difficulty_setting": "no"
        "game_rules_allow_achievements": "yes"
    }
    
    "happened": {
        "has_country_flag": "achievement has joined faction"
    }
}

I have tried various different methods having some success sorting the keys first however I cannot find a way to select the string values excluding those values already in quotes. Id be more than happy to do this in multiple steps if necessary.

For example, I know these parts get me closer..

(?:".+?") matches everything between the brackets
b([a-zA-Z0-9@_]+)b matches boundary words S might be better

But I cant combine the two to not match the 1st. I thought this would work, but it didn’t:

(?!(?:".+?")))b([a-zA-Z0-9@_]+)b

Any help would be greatly appreciated.

Thanks in advance!!!

Tags:

2

Answers


  1. 0

    You can achieve this by using negative lookbehind and negative lookahead markers. if you used something along the lines of –

    (?<!["w])w+(?!["w])

    It will match all word char groups that are not preceded by other word chars or " and that are not followed by other word chars or "

    you can replace the w+ in the middle to better fit your use-case as needed

    Login or Signup to reply.
  2. 0

    You can use this python snippet to get this done:

    import re

myjson = 'friend_in_need: { id: 3      possible: {       is_ironman: yes       
difficulty: {">": 1}       has_start_date: {"<": "1936-01-02"}      
has_any_custom_difficulty_setting: no       game_rules_allow_achievements: yes   
}   happened: {        has_country_flag: "achievement has joined faction"   }}'
x = re.sub(r"(?<!["w])w+(?!["w])", r'"g<0>"', myjson)
print(x)

    result:

    "friend_in_need": { "id": "3"      "possible": {       "is_ironman": "yes"       
"difficulty": {">": "1"}       "has_start_date": {"<": "1936-"01"-02"}      
"has_any_custom_difficulty_setting": "no"       
"game_rules_allow_achievements": "yes"   }   "happened": {        
"has_country_flag": "achievement "has" "joined" faction"   }}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search