Help with Data Extractor Pattern
I need help with an extractor pattern I have tried using DATARECORD and doing Sub-Extractor. I have also tried to regular extractor pattern. I can't grab everything between the | separately into its own variable.
{"resu": ["AAA|57|58.25502163|21.3%|3.02027205|0.3%|2.54709361|04:05:20 02/10/18", "BBB|74|109.94586822|16.5%|8.50915028|0.4%|7.86249246|04:05:21 02/10/18", "CCC|66|143.48246|29.8%|8.56625982|1.1%|-0.03586782|04:05:26 02/10/18", "DDD|29|1.23424251|-0.5%|14.94345835|0.6%|0.51478061|04:05:29 02/10/18", "EEE|50|96.6510743|30.7%|8.74840949|1.4%|-4.32567889|04:05:30 02/10/18", 841]}
I would extract it as one
I would extract it as one block, and parse it in a script.
It looks like a JSON array, but containing pipe-delimited data, which is odd, but we must deal with what we have:
String dataFromExtrator = "{\"resu\": [\"AAA|57|58.25502163|21.3%|3.02027205|0.3%|2.54709361|04:05:20 02/10/18\", \"BBB|74|109.94586822|16.5%|8.50915028|0.4%|7.86249246|04:05:21 02/10/18\", \"CCC|66|143.48246|29.8%|8.56625982|1.1%|-0.03586782|04:05:26 02/10/18\", \"DDD|29|1.23424251|-0.5%|14.94345835|0.6%|0.51478061|04:05:29 02/10/18\", \"EEE|50|96.6510743|30.7%|8.74840949|1.4%|-4.32567889|04:05:30 02/10/18\", 841]}";
// Insted of the constant I made, you would just use dataRecord.get here
JSONObject obj = new JSONObject(dataFromExtrator);
JSONArray array = obj.getJSONArray("resu");
for (int i=0; i<array.length(); i++)
{
String cur = String.valueOf(array.get(i));
resultArray = cur.split("\\|");
if (resultArray.length>1)
{
log.log(">Item " + i + " Name: " + resultArray[0]);
log.log(">Item " + i + " Timestamp: " + resultArray[7]);
}
}
Opps didnt see the reply button
How would I use dataRecord.get? Would I have to create a sub extractor pattern? I thought I would be able to get it like this
~@DATARECORD@~
I feel dumb sorry. You can delete the misplaced comment.
Where I have the JSON object,
Where I have the JSON object, you would just