topic Add a leading character to a string in Data Management Questions

Add a leading character to a string

ChristopherEdwards — Mon, 24 Nov 2014 05:39:18 GMT

Long story short, I'm trying to get County FIPS data to match from one table to the next.

One table has a string field with 3 character county FIPS codes, the other table has a longer codes where a number corresponding to each state precedes the 3 digit county code. For instance, Autauga County, Alabama is 1001 in one database but 001 in the other.

How would I go about adding a leading character to the string 001? (I figure part of the solution is to select each state and then run the field calculator on each selection, but flummoxed on how to form the expression.)

Re: Add a leading character to a string

OwenEarley — Mon, 24 Nov 2014 05:54:09 GMT

In ArcMap:

Create a STATEFIPS field (Text with a length of 2) in your layer.
Select your States and assign the State component of the FIPS code.
Create new field (Text with a length of 5) for example FINALFIPS.
Use the Field Calculator to concatenate the values: [STATEFIPS] + [FIPSVALUES]

Assuming that FIPSVALUES is the name of your 3 character county FIPS code field.

Re: Add a leading character to a string

ChristopherEdwards — Mon, 24 Nov 2014 06:10:15 GMT

Not only was this helpful but now reading your reply I see that basically that was already done but didn't understand what I was reading. So thank you!