Teknologik
New member
- Local time
- Today, 10:42
- Joined
- Feb 10, 2011
- Messages
- 7
Hello,
I require to break up a GPS reading into Longitude and lattitude but can not work out a way to do it.
i have a GPS reading
52.25844,0.614368333333333,6,1.7,FALSE,FALSE
What i want to do is split it into two fields one for Lattitude and the other longitude in a query.
For Example:
Lattitude:
52.25844
Longitude:
0.614368333333333
But want to ignore the 6,1.7,FALSE,FALSE.
Does anyone know how to do this? Any help is much appreciated.
Thanks,
I require to break up a GPS reading into Longitude and lattitude but can not work out a way to do it.
i have a GPS reading
52.25844,0.614368333333333,6,1.7,FALSE,FALSE
What i want to do is split it into two fields one for Lattitude and the other longitude in a query.
For Example:
Lattitude:
52.25844
Longitude:
0.614368333333333
But want to ignore the 6,1.7,FALSE,FALSE.
Does anyone know how to do this? Any help is much appreciated.
Thanks,