Getting Data In

how to ignore the first and last line in json file

younes17
Explorer

Is there any way to ignore first and last line from my json files?

{
"hosts": {
"sv-1000.local": [
{
"Impact": "This may help attackers to defeat time based authentications schemes.",
"Network": "DEB304C5",
"ServiceandPort": "general (icmp)",
"ScanDate": "2020-01-02 00:36"
}
]
},
"network": {
"ScanCount": "21",
"ScanDate": "2020-01-02 00:36:18",
"ID": "DEB304C5",
"Parent": "C8F90FE8",
"Name": "-CAS"
}
}

Tags (1)
0 Karma

to4kawa
Ultra Champion

props.conf

SEDCMD-ignore = s/(?ms){(.*)}/\1/
0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...