Json Regex to Capture everything inside the brackets only

David Smith

SendAction
2018-10-18T20:04:01.000000
{
"EventDate": "2018-10-18T20:04:01.8278435",
"HeaderVersion": "1.0.0.0",
"Details": [
{
"ApplicationGuid": "3e8eb057-59da-4bfb-9d6c-a533a8f9bd86",
"Discount": 0.0,
"EventType": "ViewDetails",
"ItemID": "793",
"ProductID": "737",
"ProductName": "Land - Large Roads",
"ProductPrice": 19.95,
"Promo": "",
"Quantity": 0,
"TransAmount": 0
}
],
"UserID": "0"
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

David Smith4y ago
Your regex only work for ine send action. Your regex does not work for multiple send action records. Please check online regex validator and you will see.

Use this below against your regex and you will see.

SendAction
2018-10-18T20:04:01.000000
{
"EventDate": "2018-10-18T20:04:01.8278435",
"HeaderVersion": "1.0.0.0",
"Details": [
{
"ApplicationGuid": "3e8eb057-59da-4bfb-9d6c-a533a8f9bd86",
"Discount": 0.0,
"EventType": "ViewDetails",
"ItemID": "793",
"ProductID": "737",
"ProductName": "Land - Large Roads",
"ProductPrice": 19.95,
"Promo": "",
"Quantity": 0,
"TransAmount": 0
}
],
"UserID": "0"
}
SendAction
2018-10-18T20:04:01.000000
{
"EventDate": "2018-10-18T20:04:01.8278435",
"HeaderVersion": "1.0.0.0",
"Details": [
{
"ApplicationGuid": "3e8eb057-59da-4bfb-9d6c-a533a8f9bd86",
"Discount": 0.0,
"EventType": "ViewDetails",
"ItemID": "793",
"ProductID": "737",
"ProductName": "Land - Large Roads",
"ProductPrice": 19.95,
"Promo": "",
"Quantity": 0,
"TransAmount": 0
}
],
"UserID": "0"
}
Muhammad Imran Ansari4y ago
Use the following Regex code to get on brakets string:
// Place you Json into file and Load here
string yourJson = File.ReadAllText(@"E:\yourJson.json");
string pattern = @"\{([\s\S]*)\}";

Regex rx = new Regex(pattern);
Match m = rx.Match(yourJson);

if (m.Success)
{
        var theValue = m.Value;
}