AnsweredAssumed Answered

Split Latitude,Longitude field

Question asked by MattS on Jan 29, 2014
Latest reply on Feb 2, 2014 by MattS


Split Latitude,Longitude field

Your post

     I have fields with Lat,Long coordinates from google maps.
     I would like split them for futher calculation in:

  1.           a latitude field
  3.           a longitude field

     The data in my field looks like this: 50.123456,02.123456
     but can also be +xx.xxxxxx,+xxx.xxxxxx

     Is there a way to get all data before the , in the latitude field and all the data behind the, in the longitude field.

     Any help would be very much appreciated as I am new at FM