Skip to main content
sdettling222
sdettling222
Known Participant
Jul 10, 2017 11:25 PM UTC
Answered

Best way to reorganize coordinates....

Hello All......

I need to reorganize longitudes and latitudes......

Here is what I have right now:

-81.93,39.19;-81.77,39.34;-81.38,39.2;-81.65,38.99

What I need is the following:

39.19,-81.93;39.34,-81.77;39.2,-81.38;38.99,-81.65

I have tried a number of methods, but just can't get it right. Now I going crazy.....

The above is represented with the #polygons# variable.

Any input would be appreciated.

Thank you so much!!!!

    This topic is closed to new replies. Start a new post to keep the conversation going.
    BKBK
    BKBKCorrect answer
    Community Expert
    Jul 11, 2017 10:38 AM UTC

    <cfset newList = "">

    <!--- Treat oldList as list having delimiter ; --->

    <cfset oldList = "-81.93,39.19;-81.77,39.34;-81.38,39.2;-81.65,38.99">

    <cfloop list="#oldList#" index="element" delimiters=";">

        <!--- Reverse the coordinates, treating each list element as list having delimiter , --->

        <cfset x = listGetAt(element,2)>

        <cfset y = listGetAt(element,1)>

        <!--- Create newList as list having delimiter ; --->

        <cfset newList = listAppend(newList, x & "," & y, ";")>

    </cfloop>

    <cfoutput>

        oldList: #oldList# <br>

        newList: #newList#

    </cfoutput>

    View reply

    5 replies

    BKBK
    Community Expert
    BKBKCommunity ExpertCorrect answer
    Community Expert
    Jul 11, 2017 10:38 AM UTC

    <cfset newList = "">

    <!--- Treat oldList as list having delimiter ; --->

    <cfset oldList = "-81.93,39.19;-81.77,39.34;-81.38,39.2;-81.65,38.99">

    <cfloop list="#oldList#" index="element" delimiters=";">

        <!--- Reverse the coordinates, treating each list element as list having delimiter , --->

        <cfset x = listGetAt(element,2)>

        <cfset y = listGetAt(element,1)>

        <!--- Create newList as list having delimiter ; --->

        <cfset newList = listAppend(newList, x & "," & y, ";")>

    </cfloop>

    <cfoutput>

        oldList: #oldList# <br>

        newList: #newList#

    </cfoutput>

    Translate
    sdettling222
    sdettling222Author
    Known Participant
    Jul 12, 2017 3:21 PM UTC

    Thank you so much for your help!!!! I will try and implement.

    Appreciate your feedback!!!

    Translate
    haxtbh
    Inspiring
    Jul 11, 2017 7:58 AM UTC

    What have you tried? Show us some code....

    Translate
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices