Splunk Search

How to remove [] in Json format data?

vikram1583
Explorer

I have a field properties.policies  in json format 

field value: [{"fieldname":"fieldvalue","fieldname":"fieldvalue","fieldname":"fieldvalue",[priview] "fieldname":"fieldvalue",[]}]

i want to remove first and last [] so that other fields can populate 

can some one send me the rex please ?

Thanks in advance

 

Labels (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| eval field=trim(field,"[]")
0 Karma

richgalloway
SplunkTrust
SplunkTrust

What have you tried so far? 

Parsing JSON using regular expressions can be challenging.  Have you tried the spath command?

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...