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
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+(?