Split Latitude,Longitude field
I have fields with Lat,Long coordinates from google maps.
I would like split them for futher calculation in:
- a latitude field
- 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