Question

Renaming fieldnames

  • 10 March 2020
  • 2 replies
  • 2 views

Badge +3

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

Badge +2

@gisgeek Have you looked at SchemaMapper?

Badge +3

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