any idea what the best way to extract the xy location from this string would be?
{"type":"Point","coordinates":[-1.35507,52.83477]}
Page 1 / 1
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:
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
thank you both for your help still getting my head around the regex expressions. perfect :)
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.