Calculate Station from Decimal

Here's a little python function to calculate the stationing text from a decimal number

def calculate(value):
    valDecimal =  value.split('.')[1][:2]
    if len(valDecimal) == 1:
        valDecimal = valDecimal + "0"
    varLast = value.split('.')[0][-2:]
    varFirst = value.split('.')[0][:-2]
    return varFirst + "+" + varLast + "." + valDecimal

calculate( str(!BEGIN_STATION!) )

Input - 5622.068
Output - 56+22.06

Popular posts from this blog

How to Transfer Domains to a New Database

Domains.  AmIright? A domain is ESRI's fancy word for a drop-down or pick-list of choices.  Recently I was tasked with moving a dataset from one server to another.  This dataset used domains. I thought I'd follow the ESRI way by importing the data into the new database.  However, I discovered that this lost all of the domains. I didn't want to have to retype all of my domains, so I tried to copy and paste it. That shouldn't work, right?  I mean, that's not using any of ESRI's tools. Surprise, surprise - a simple copy and paste not only moved the data, but it also moved all of the domains into the database. Seems rather counter-intuitive, doesn't it?  I'm also happy at how simple this makes it. So, the next time you need to move data with domains, know that a simple copy and paste will do the trick. Happy GIS-ing! Lindsy Hales Bentley
Read more