Skip to main content
Question

Renaming fieldnames


gisgeek
Contributor
Forum|alt.badge.img+9

I have census data in csv format and would like to rename several fields. Basically I want to rename fields by renaming specific words Private to Pvt, Dwelling to Dwlg. I also want each word in Proper case so the fieldnames aren't so long. Hopefully someone can help me with how to tackle this.

2 replies

Forum|alt.badge.img+2

@gisgeek Have you looked at SchemaMapper?


bwn
Evangelist
Forum|alt.badge.img+26
  • Evangelist
  • March 11, 2020

You can use BulkAttributeRenamer. This does search and replace of the parts of Attribute Names fitting specific conditions.

Examples below for Search and Replace, and Change Case. Note RegEx is the more powerful/flexible option for string replace, but requires to learn a bit about RegEx. The "\\1" "\\2" tells the Transformer in RegEx mode to return the strings within each of the Bracketed expressions (.*) which is the parts of the string outside the string that you want to replace.

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings