Hello Tom -I apologize for not being able to respond to your post earlier.The easiest way to do what I think you are trying to do will be to leverage the Field Calculator and Java string functions available with the 10.2.2 product release.Given a block of JSON input:
{
"Attributes": {
"name": "Some name...",
"date": "2/17/2014 15:31:45"
},
"Location": "31.555114:-117.458182:12.792526:10.000000:3.000000:0.000000"
}
You could design a GeoEvent Service something like the one illustrated below to find the index of the ':' delimiters within the event attribute string and then pull the substring found between those index values.[ATTACH=CONFIG]34963[/ATTACH](Click to Enlarge)This is going to depend on your "latitude" and "longitude" always being found within the first two substring values of the Location attribute string. The output you should expect would look something like:
[
{
"Attributes": {
"name": "Some name...",
"date": 1392679905000
},
"Location": "31.555114:-117.458182:12.792526:10.000000:3.000000:0.000000",
"IdxA": 9,
"IdxB": 21,
"Latitude": 31.555114,
"Longitude": -117.458182
}
]
Hope that helps -RJ