This seems like it should be an EASY thing to do in Python, but it is driving me crazy. (This was so easy to do in VB!) I have latitude and longitude fields (double) with 6 or decimals. I want to round or truncate the number of decimals to 5 decimals and then convert the resulting number to a string field.
I can use the str() option to convert the latitude field to string without a problem, but the negative sign causes an issue with the longitude conversion. If I multiple my (all negative) longitude values by -1 I can get all positive text values in the new text field. But when I try to add the negative sign back to the new text field, I get inconsistent results. Some of the rows update with the negative and some don't. Even if this method did work, this still doesn't solve my need to truncate the decimals to 5 instead of 6 decimals for both the X and Y text fields. I have hundreds of thousands of rows in the data so I need an efficient way to convert the field values.
