Latest Contributions by MichelleCouden1

‎10-27-2014

WWHHHooooaaaa!!! That was it. Sorry, we didn't think of that earlier. I'll have to remember that for future questions. Thank you again for all your help and being patient.

‎10-27-2014

Oh Yeah, on the notes. I usually just print the discussion out. I'm going to continue to try to figure out this error of "zero length field name in format". Thanks again for your help.

‎10-27-2014

OK, I'll try all of that and see how it turns out. Thank you very much for all your help today!

‎10-27-2014

Could this error be because it is a dbf not a shapefile or feature class??

‎10-27-2014

Yeah, I have no idea what is going on. I just made 3 new text fields and filled the first two with the data and then tried formula on third field. It still gives me an error of "zero length field name in format".

‎10-27-2014

Course the other thing is the first part can only be 4 numbers so how do I get it to add only the numbers I need? Also, no periods. I think I fix that by taking out the last {} right?

‎10-27-2014

Yeah, I'm not sure what is going on. I still get an error zero length field name in format. Could it be that my AControl and ASection are double fields not string??

‎10-27-2014

Do I put something in place of the % marks? I am getting a syntax error.

‎10-27-2014

Yes! I just looked to double check. I'll attach 2 screen shots. One of the table one of the field calculator. Let me know if you need anything else. I am going to keep trying to figure it out.

‎10-27-2014

Typing it exactly like you have it. I am getting a ValueError : zero length field name in format. I have those field names so I'm not sure why it doesn't like it.

‎10-27-2014

I am also trying print "%s-%s" % (!ACONTROL!.zfill(4), !ASECTION!.zfill(2)). It also contracts a syntax error. Do I have to put anything before the print? Should it be (period) .print "%s-%s"% .......

‎10-27-2014

I'm thinking I have to have it as a shapefile because I keep getting errors for the code. It keeps saying invalid syntax. I'm typing them as is. Do I have to put something in front of print?? I am typing in field calculator box print"00{}-0{}".format(ACONTROL,ASECTION)

‎10-27-2014

I can write this code in Field calculator right??

‎10-24-2014

I have two fields that I need to concatenate together but I need to add zeros so one said has 4 digits and the other side has 2 digits. Both separated with a hypen. For Example, 0024-14. This is the code I have written am I close??? Left([ACONTROL], 4, "-") & Right([ASECTION], 2) So, it would be field ACONTROL with 4 digits and ASECTION with 2 digits.

‎10-13-2014

Thank You bunches! I see where I messed up. My -KG had no spaces so it was thinking it worked the code when the code I provided was wrong. Python. Gotta remember it wants spaces correct! Thanks again.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by MichelleCouden1

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Re: Adding zeros or numbers in a Field

Adding zeros or numbers in a Field

Re: Changing Field Characters

Re: Loop inside a loop or Nested Loop in VBA

Help with Script Tool for Creating PDFs from MXDs