Archive

Need help in extracting json fields

Nadhiyaa
Path Finder

Hi

Below is my json data format .

 organisations: {   [-] 
    :   {   [+] 
    }   
     adbsafegate.com:   {   [-] 
     active:     0  
     active_selected:    0  
     all:    0  
     on_realm:   0  
    }   
     aeroflot.ru:   {   [-] 
     active:     0  
     active_selected:    0  
     all:    25 
     on_realm:   5  
    }   
     airalgerie.dz: {   [-] 
     active:     0  
     active_selected:    0  
     all:    3  
     on_realm:   1  
    }   
     airastana.com: {   [-] 
     active:     1  
     active_selected:    1  
     all:    3  
     on_realm:   1  
    }

}

i want it to extract like below table format :

organisations on_realm
adbsafegate 0
aeroflot 5
airalgerie 1
airastana 1

Kindly help.Thanks

Tags (1)
0 Karma

jutzasconsist
New Member

Hi Nadhiyaa,

may be this helps you getting started:

\}\s+(?<EXTRACTION1>\w+)|on_realm:\s+(?<EXTRACTION2>\d)

It will extract the lines below your headline "organisations on_realm"

This should also work for extractig all of the relevant data:
^\s+(?\w+):\D+}|(?\w+).\w+:\s+{\s+[-]|\w+:\s+\d+\s+\w+:\s+\d+\s+\w+:\s+\d+\s+(?\w+)|:\s+(?\d+)\s+

0 Karma
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!