Skip to main content
Question

How to extract Coordinates from XML

  • October 31, 2017
  • 2 replies
  • 49 views

Forum|alt.badge.img

Can someone give me a hand on the RegExpression to extract a bunch of coordinates from this XML table. The column they are stored in has a lot of other information in various formats.

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.

2 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2077 replies
  • October 31, 2017

Hi @tlabs,

I created a example in your case.

I used the Transformer StringSearcher and configured the expression:

(^N[0-9]+:[0-9]+:[0-9]+.[0-9]+) (W[0-9]+:[0-9]+:[0-9]+.[0-9]+)

 

Thanks,

Danilo


takashi
Celebrity
  • 7843 replies
  • November 1, 2017
The screenshot just shows a single pair of latitude and longitude. Where is the XML table?