Skip to main content
Question

Adding Decimal to X,Y

T
Forum|alt.badge.img
I have recieved some XY Data that does not seem to be correct as there are 7 digits for my X coordinate and 9 digits for my Y.  I would like to add a decimal after the 6 digit for the X and at the 7th digit for my Y.  

 

 

Thoughts?

 

 

 

    4 replies

    takashi
    Influencer
    • takashiInfluencer
    • August 18, 2014
    Hi,

     

    I would multiply X by 0.1 and Y by 0.01, using AttributeCreator or ExpressionEvaluator.

     

    Takashi
    david_r
    Celebrity
    • david_rCelebrity
    • August 19, 2014
    Hi,

     

     

    also remember that you can freely treat your numbers as strings in FME, so you can also use the StringConcatenator, etc to add digits at the end or the SubstringExtrator to split up any digit for further manipulation.

     

     

    David
    erik_jan
    Contributor
    Forum|alt.badge.img+18
    • erik_janContributor
    • Contributor
    • August 19, 2014
    The Scaler transformer allows you to scale X, Y and Z values by multiplying the ordinates.

     

     

    Kind regards,

     

    Erik Jan Bodewitz

     

    Vicrea
    gio
    Contributor
    Forum|alt.badge.img+15
    • gioContributor
    • Contributor
    • August 19, 2014
    Hi,

     

     

    you could just use claculations:  number + digit*pow(10,POSITION)

     

     

    Maybe it is more comfortable use string operations:LEFT (NUMBER,7)&DIGIT&RIGHT(NUMBER,2)

     

    Or u can split the number with no delimmiter and use list operations on it.

     

     

    Reply


    Helpful Members This Week

    Community Stats

    31,255
    Posts
    118,537
    Replies
    38,847
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.