I have source field geocode and value as below..
source - Geocode = 40.145000|-84.24860
I need to parse above value into Latitude & Longitude
Latitude = 40.145
Longitude = -84.2486
I am using below transformations
Latitude = StringToDecimal(Field(geocode,"|",1))
Longitude = StringToDecimal(Field(geocode,"|",2))
The outpur I am getting is
Latitude = 40.145
Longitude = -84.249
I tried using using RTYPE option 'floor' on StringToDecimal but values are getting truncated.
Is there a way to convert string to decimal with any kind of rounding..
StringToDecimal - how to avoid to Rounding
Moderators: chulett, rschirm, roy
StringToDecimal - how to avoid to Rounding
Thank you,
Anu
Anu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: