Select to view content in your preferred language

Change fields to uppercase

167
4
Jump to solution
2 weeks ago
SanchezNuñez
Frequent Contributor

Good afternoon,

What is the best way to change field names to uppercase in UN Feature Classes?

Thanks

0 Kudos
1 Solution

Accepted Solutions
RobertKrisher
Esri Regular Contributor

As long as the field isn't associated with a network attribute or something required by the utility network, you can do this the same way you'd alter any other field in a geodatabase. The Design view for fields or the Alter field tool.

Edit: @VishApte_NGIS mentions below that if you just switch a field from lower case to upper case, it will not change the field. This means you must alter the fields(s) twice, once to make it upper chase (with an extra adornment like 1) and a second time to remove the adornment. To make this easier, consider using the Alter Fields (multiple) tool to make the two calls.

View solution in original post

4 Replies
RobertKrisher
Esri Regular Contributor

As long as the field isn't associated with a network attribute or something required by the utility network, you can do this the same way you'd alter any other field in a geodatabase. The Design view for fields or the Alter field tool.

Edit: @VishApte_NGIS mentions below that if you just switch a field from lower case to upper case, it will not change the field. This means you must alter the fields(s) twice, once to make it upper chase (with an extra adornment like 1) and a second time to remove the adornment. To make this easier, consider using the Alter Fields (multiple) tool to make the two calls.

AyanPalit
Esri Regular Contributor

@SanchezNuñez Consider changing the Alias (vs. Field Name) to uppercase.

Ayan Palit | Principal Consultant Esri
0 Kudos
VishApte_NGIS
Occasional Contributor

I believe to change the case for fields using alter field tool, you will need to rename the field to something different first e.g. MyField to MyField1 and then from MyField1 to MYFIELD. Changing directly from MyField to MYFIELD has no effect.

 

JoseSanchez
Frequent Contributor

Good morning,

With Esri's assistance we are using a feature in the FME that uppercases field names in the asset package.

Thanks

0 Kudos