topic Re: Using Field Calculator to add a character in a field in ArcPro in ArcGIS Pro Questions

Using Field Calculator to add a character in a field in ArcPro

ZachSvoboda — Thu, 22 Aug 2019 18:54:16 GMT

I'm attempting to add a character to an ID field in ArcPro (eg. 2.14 -> 2.014, 2.15 -> 2.015, etc.). Rather than manually do the couple hundred attributes, I'm sure there is a way to do this with a code block in Field Calculator but I can't seem to figure it out. Does anyone have any tips? Thank you!

Re: Using Field Calculator to add a character in a field in ArcPro

rachelg_esri — Thu, 22 Aug 2019 19:56:17 GMT

Hello Zach,

Is there a pattern to where you want to place the character? In other words, is it always going after the second character (in the above example the 2 and the period are the first two characters), or is it always going to be after the decimal, etc?

There should be a way to split the string, concatenate it with the desired character, and then re-concatenate the string halves. It'll only work if there's a pattern though.

Thanks!

Rachel

Esri Support Services

Re: Using Field Calculator to add a character in a field in ArcPro

ZachSvoboda — Thu, 22 Aug 2019 20:14:49 GMT

Yes, it will always be after the decimal. Basically it's a double ID with the number before the decimal being the group ID and after the decimal being the attribute ID and I'm just trying to add a hundreds place to the attribute ID.

I've done similar things in Desktop but I'm not very experienced with Pro (or python code blocks) and believe I'm just missing some element or having something in the wrong spot.

Thanks for the response!

Re: Using Field Calculator to add a character in a field in ArcPro

rachelg_esri — Thu, 22 Aug 2019 20:30:18 GMT

Hello Zach,

Assuming:

The input values are in a Text field
There's only one period
You're always wanting to add a zero after the period

Then the following should work for you in Field Calculator

NewField=

addzero(!NumberBefore!)

Code Block=

def addzero(inputString):
   beforePeriod = inputString.split(".")[0]
   afterPeriod = inputString.split(".")[1]
   concatenateAll = beforePeriod+".0"+afterPeriod
   return concatenateAll

Here's a screenshot of the whole thing:

Let me know if that works?

Best regards,

Rachel

Esri Support Services

Re: Using Field Calculator to add a character in a field in ArcPro

rachelg_esri — Thu, 22 Aug 2019 21:01:03 GMT

Hello Zach,

In theory, you could also just do

!NumberBefore!.replace(".",".0")

This should just replace the period with a period and a zero. You should only have to put that in the top section and not need a Code Block, I think.

Best regards,

Rachel

Esri Support Services

Re: Using Field Calculator to add a character in a field in ArcPro

ZachSvoboda — Thu, 22 Aug 2019 21:12:33 GMT

That worked!

Thank you Rachel