Skip to main content
Solved

Extract XY from this string


Forum|alt.badge.img

any idea what the best way to extract the xy location from this string would be?

{"type":"Point","coordinates":[-1.35507,52.83477]}

Best answer by davideagle

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

View original
Did this help you find an answer to your question?

5 replies

davideagle
Contributor
Forum|alt.badge.img+21
  • Contributor
  • Best Answer
  • June 13, 2016

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


david_r
Celebrity
  • June 13, 2016

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:


davideagle
Contributor
Forum|alt.badge.img+21
  • Contributor
  • June 13, 2016
david_r wrote:

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


Forum|alt.badge.img

thank you both for your help still getting my head around the regex expressions. perfect :)


revesz
Contributor
Forum|alt.badge.img+15
  • Contributor
  • June 13, 2016

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings