i want a way to get the wrong coordinates (example : easting 3628623.38(7) digits and northing 4565105.96(7) digits to be comes as rejected output and the others which needs to b swap between x column and y column
Question
i have an excel which contain bulk coordinates in two formats, some of them in utm and others are geographic. The problem is some of them are wrong and some needs to b reverse ( x needs to be in y column and y needs to b in x column) .
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 7843 replies
Hi @mehar, for example, you can use the AttributeCreator to swap two columns like this.
The problem is how you can determine rows in which the two columns should be swapped. How can you determine if the values of x, y are reversed?
@mehar There is also CoordinateSwapper. But as @takashi points out, the real problem is determining which coordinates to swap. Once you've determine that perhaps TestFilter and CoordinateSwapper will do what you want.