topic Re: how to do math on string fields in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355840#M15700 <HTML><HEAD></HEAD><BODY><P>Matthew, I unmarked your reply and marked Robert's as the answer since your comment saying thanks isn't really the answer to your own question.</P></BODY></HTML> Fri, 12 Jun 2020 16:59:49 GMT JoshuaBixby 2020-06-12T16:59:49Z how to do math on string fields https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355833#M15693 <HTML><HEAD></HEAD><BODY><P>I have a drain pipe layer that includes fields for upstream elevation, downstream elevation, and length.&nbsp; I want to calculate the slope.&nbsp; However, the fields are all string fields.&nbsp; Is there a way to do this in ArcGIS Pro without adding or otherwise changing the fields?&nbsp; I remember in the old days with avenue you could use a thing like {field}.asnumber or {field}.asstring to a calculate function to do stuff like this, but I don't know if there's a way to do it in Pro.&nbsp; Thanks!</P></BODY></HTML> Thu, 11 Jun 2020 16:00:37 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355833#M15693 Matt-Barrett 2020-06-11T16:00:37Z Re: how to do math on string fields https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355834#M15694 <HTML><HEAD></HEAD><BODY><P>Use the field calulator with python and <A href="https://www.w3schools.com/python/ref_func_int.asp">the int() function.</A></P></BODY></HTML> Thu, 11 Jun 2020 16:04:45 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355834#M15694 JoeBorgione 2020-06-11T16:04:45Z Re: how to do math on string fields https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355835#M15695 <HTML><HEAD></HEAD><BODY><P>Thank you.</P><P></P><P>But would that round up my decimals?&nbsp;&nbsp;</P></BODY></HTML> Thu, 11 Jun 2020 16:16:28 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355835#M15695 Matt-Barrett 2020-06-11T16:16:28Z Re: how to do math on string fields https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355836#M15696 <HTML><HEAD></HEAD><BODY><P>Related you could use the field calculator with Python and the <A href="https://www.w3schools.com/python/ref_func_float.asp">float() function</A> then.</P></BODY></HTML> Thu, 11 Jun 2020 17:23:53 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355836#M15696 Robert_LeClair 2020-06-11T17:23:53Z Re: how to do math on string fields https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355837#M15697 <HTML><HEAD></HEAD><BODY><P>that sounds perfect!&nbsp; Thanks!</P></BODY></HTML> Thu, 11 Jun 2020 17:29:57 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355837#M15697 Matt-Barrett 2020-06-11T17:29:57Z Re: how to do math on string fields https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355838#M15698 <HTML><HEAD></HEAD><BODY><P>Please mark one of the replies as correct to close out the question once you get it working.</P></BODY></HTML> Fri, 12 Jun 2020 16:44:45 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355838#M15698 JoshuaBixby 2020-06-12T16:44:45Z Re: how to do math on string fields https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355839#M15699 <HTML><HEAD></HEAD><BODY><P>So I used the float function.&nbsp; It mostly worked.&nbsp; Ended up with values in scientific notation.&nbsp; Got it worked out in the end though, so thank you to those who replied.</P></BODY></HTML> Fri, 12 Jun 2020 16:50:07 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355839#M15699 Matt-Barrett 2020-06-12T16:50:07Z Re: how to do math on string fields https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355840#M15700 <HTML><HEAD></HEAD><BODY><P>Matthew, I unmarked your reply and marked Robert's as the answer since your comment saying thanks isn't really the answer to your own question.</P></BODY></HTML> Fri, 12 Jun 2020 16:59:49 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-do-math-on-string-fields/m-p/355840#M15700 JoshuaBixby 2020-06-12T16:59:49Z