AnsweredAssumed Answered

Extracting coordinates from string

Question asked by rasmush on Jan 15, 2018
Latest reply on Jan 25, 2018 by rasmush

Hello, 

 

I've got strings like this streaming into my geoevent server. (10.5.1)

 

{protocol":"RTCU,"id"":""218244290","gps"":""$GPRMC,220359.00,A,5546.4919,N,01230.3042,E,0.0,0.0,150118,0.0E,A*05","distatus"":""0;0;0;0;0;0","aistatus"":""0;0;0;0","volt"":""139","event"":""MAXPER","batt"":""5","temp"":""1200","ts"":""1200521038""}

{protocol":"RTCU,"id"":""218244290","gps"":""$GPRMC,215513.00,A,5546.4919,N,01230.3042,E,0.0,0.0,150118,0.0E,A*05","distatus"":""0;0;0;0;0;0","aistatus"":""0;0;0;0","volt"":""139","event"":""MAXPER","batt"":""5","temp"":""1200","ts"":""1200520513""}

 

(yes the vehicle is stationary at the moment)

 

The coordinates are in the string (needs division with 100 tho) and I need to extract these coordinates (5546.4919,N,01230.3042,E) and create point features from them.

 

But I am quite lost. It seems that Field Calculator using RegEx would be the proper processor to use, but I cant get it to do what I expect it to do. 

 

Any help would be greatly appreciated!!

 

br,

 

Rasmus

Outcomes