2 Replies Latest reply on Feb 2, 2014 2:26 PM by MattS

    Split Latitude,Longitude field

    MattS

      Title

      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
      2.      
      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