@KRusso wrote:
the data had strange characters in it. This fixed it: Longitude =Compress(tranwrd(Longitude,'0A'x,' '),,'kw')
So what is the goal of those function calls?
You convert the linefeed into a space. Then you eliminated all of the non-printable characters, even the linefeeds you just remove. So why not just remove the TRANWRD() function call?
Or did you mean to convert non-breaking spaces ('A0'X) to spaces first? That character will NOT be removed by COMPRESS() as apparently COMPRESS() thinks it IS a printable character.
Why not just keep the digits and other characters used to represent numbers?
lng=input(compress(longitude,'+-.E','kd'),32.);
... View more