any idea what the best way to extract the xy location from this string would be?
{"type":"Point","coordinates":[-1.35507,52.83477]}
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+22- Contributor
- Best Answer
regex.fmw should sort you out. Use regex to grab the contents of the square brackets and then split the string in the usual way with the AttributeSplitter.
Hope that helps, Dave
In addition to the regex-based solution by @1spatialdave, you can also use the JSONExtractor (since what you posted looks to be JSON) and do the whole extraction with a single transformer.
To extract your coordinates into the attributes x and y, use:
+22- Contributor
In addition to the regex-based solution by @1spatialdave, you can also use the JSONExtractor (since what you posted looks to be JSON) and do the whole extraction with a single transformer.
To extract your coordinates into the attributes x and y, use:
Nice one @david_r
+21- Contributor
Well, it is the geometry part of a GeoJSON.
Actually GeometryReplacer might be your best friend. It converts the string to feature if you tell the transformer that it is a GeoJSON :)
So you can use the CoordinateExtractor and no coding involved.