Question

How to extract Coordinates from XML

  • 31 October 2017
  • 2 replies
  • 4 views
T
Badge

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.

2 replies

danilo_fme
Rank
Userlevel 4
Badge +30

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
Rank
Userlevel 2
Badge +17
The screenshot just shows a single pair of latitude and longitude. Where is the XML table?

 

 

Reply


Community Stats

28,723
Posts
109,511
Replies
36,559
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.