Question

Using BulkAttributeRenamer to rename attribute names to only the first 10 characters.

  • 11 April 2019
  • 1 reply
  • 23 views
ngstoke
Badge

Hello,

 

I'm having issues when trying to get the BulkAttributeRenamer to perform the following:

 

I need trim all attribute names down to only 10 characters in length.

When I set the Parameters for Action: to Regular Expression Replace and use this regular expression:

^.{10}

 

I'm able to match all the first 10 characters, but I actually don't need to replace these, I just want to use the matches to become the new attribute name. Am I going about this the wrong way with a regular expression? Any help is greatly appreciated.

 

Example:

Old Attribute Name ----> AREA_IMP_TEAM

New Attribute Name ----> AREA_IMPL_

 

1 reply

debbiatsafe
Rank
Userlevel 3
Badge +17

Hi @ngstoke

Have you seen this previous Q&A post? I would recommend trying the solution in @egomm's answer. I believe that should trim the attribute names to the first 10 characters using the BulkAttributeRenamer.

Reply


Community Stats

28,659
Posts
109,313
Replies
36,529
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.