Grafana World Map

Im trying to plot submissions onto a world map using the infinity JSON plugin, i can get all the information from the json api and displayinto a table but i can’t seem to split the json string using regex.


value:“lat=51.491954, long=-0.238509, alt=7.071688, hAccuracy=65.000000, vAccuracy=10.000000, timestamp=2021-01-05T11:40:25Z”

how can i use reg ex to split into another column that lat and long values to display on world map?


This is for LogQL :
regexp ‘^(P\w*),\s(P\w*),’

Good Luck

Thanks, but i managed to modify the json and split the lat and long separate