How do I use a regular expression to extract all 22 entries of Message field with
left boundry = "Messages": [
right boundry = ],
Especially I need following extracted for some of the message fields...
"Transportation Expenses: Collision or Comprehensive coverage is required for vehicle 1.",
"Transportation Expenses: Collision or Comprehensive coverage is required for vehicle 2."
Message:{
"Activity History": [
{
"SequenceNumber": 1,
"Action": "Agent Id > asdf",
"Context": "Home",
"Messages": [],
"TimeStamp": "2017-02-07T13:30:07"
},
{
"SequenceNumber": 2,
"Action": "Initiate_Issuance > xasdf",
"Context": "Home",
"Messages": [],
"TimeStamp": "2017-02-07T13:30:07"
},
{
"SequenceNumber": 3,
"Action": "Create Easy Quote",
"Context": "Create Quote",
"Messages": [],
"TimeStamp": "2017-02-07T13:30:51"
},
{
"SequenceNumber": 4,
"Action": "Adding a driver from prefill",
"Context": "Create Quote>Prefill",
"Messages": [],
"TimeStamp": "2017-02-07T13:31:31"
},
{
"SequenceNumber": 5,
"Action": "Adding a driver from prefill",
"Context": "Create Quote>Prefill",
"Messages": [],
"TimeStamp": "2017-02-07T13:31:31"
},
{
"SequenceNumber": 6,
"Action": "Adding a vehicle from prefill",
"Context": "Contact",
"Messages": [],
"TimeStamp": "2017-02-07T13:31:34"
},
{
"SequenceNumber": 7,
"Action": "Adding a vehicle from prefill",
"Context": "Contact",
"Messages": [],
"TimeStamp": "2017-02-07T13:31:34"
},
{
"SequenceNumber": 8,
"Action": "residence-info",
"Context": "Contact",
"Messages": [],
"TimeStamp": "2017-02-07T13:32:02"
},
{
"SequenceNumber": 9,
"Action": "Validate Vehicle Information",
"Context": "Vehicles",
"Messages": [],
"TimeStamp": "2017-02-07T13:33:25"
},
{
"SequenceNumber": 10,
"Action": "Save for VIN",
"Context": "",
"Messages": [],
"TimeStamp": "2017-02-07T13:33:25"
},
{
"SequenceNumber": 11,
"Action": "Validate Driver Information",
"Context": "Drivers",
"Messages": [],
"TimeStamp": "2017-02-07T13:35:02"
},
{
"SequenceNumber": 12,
"Action": "Order CR",
"Context": "Reports",
"Messages": [],
"TimeStamp": "2017-02-07T13:35:03"
},
{
"SequenceNumber": 13,
"Action": "crossindices",
"Context": "Reports",
"Messages": [],
"TimeStamp": "2017-02-07T13:35:05"
},
{
"SequenceNumber": 14,
"Action": "crossindices",
"Context": "Reports",
"Messages": [],
"TimeStamp": "2017-02-07T13:35:05"
},
{
"SequenceNumber": 15,
"Action": "Order LIS",
"Context": "Reports",
"Messages": [],
"TimeStamp": "2017-02-07T13:35:09"
},
{
"SequenceNumber": 16,
"Action": "Fetch CR",
"Context": "Reports",
"Messages": [],
"TimeStamp": "2017-02-07T13:35:14"
},
{
"SequenceNumber": 17,
"Action": "rates",
"Context": "Reports",
"Messages": [
"Transportation Expenses: Collision or Comprehensive coverage is required for vehicle 1.",
"Transportation Expenses: Collision or Comprehensive coverage is required for vehicle 2."
],
"TimeStamp": "2017-02-07T13:35:48"
},
{
"SequenceNumber": 18,
"Action": "package-rates",
"Context": "Reports",
"Messages": [
"Transportation Expenses: Collision or Comprehensive coverage is required for vehicle 1.",
"Transportation Expenses: Collision or Comprehensive coverage is required for vehicle 2."
],
"TimeStamp": "2017-02-07T13:35:49"
},
{
"SequenceNumber": 19,
"Action": "Update Premium > rates",
"Context": "Coverages",
"Messages": [
"Transportation Expenses: Collision or Comprehensive coverage is required for vehicle 1.",
"Transportation Expenses: Collision or Comprehensive coverage is required for vehicle 2."
],
"TimeStamp": "2017-02-07T13:37:18"
},
{
"SequenceNumber": 20,
"Action": "Policy Package > package-rates",
"Context": "Coverages",
"Messages": [
"Transportation Expenses: Collision or Comprehensive coverage is required for vehicle 1.",
"Transportation Expenses: Collision or Comprehensive coverage is required for vehicle 2."
],
"TimeStamp": "2017-02-07T13:37:29"
},
{
"SequenceNumber": 21,
"Action": "Print Documents",
"Context": "Coverages",
"Messages": [],
"TimeStamp": "2017-02-07T13:38:04"
},
{
"SequenceNumber": 22,
"Action": "Save Popup>Save & Exit",
"Context": "Coverages",
"Messages": [],
"TimeStamp": "2017-02-07T13:38:29"
}
]
}
... View more