AnsweredAssumed Answered

pad zeros

Question asked by cpregosch_BucksGIS on Apr 3, 2018
Latest reply on May 15, 2018 by Hornbydd

I am trying to insert a link into a pop up to a map about regional transit services. The url for all routes less than 100 have one or two zeros in front of the route number, ie 001 or 055. However, the route column on the attribute table only has the route number ie 1 or 55. Therefore, when I set the link to {Route} routes less then 100 come back with a 404 error. Is there anyway I can use an expression to pad it out with zeros or find another way to navigate around this?

 

Note, this live open data from our regional transit provider so I can't generate a a new column with the padded out route numbers.

 

Thank You!

Outcomes