Skip to main content
  • EN

Is it possible to do a substring(0,10) with the BulkAttributeRenamer? I want to simulate truncating the columns as writing to shape does. I know I can do this with a SchemaMapper, this is my current workaround.

Hi @nielsgerrits, yes it's possible. Try this.

Text To Find: ^(.{10}).*
String: \1

0684Q00000ArJLtQAN.png

You can use the regex replacement method. For example, this will truncate all attribute names to the first 10 characters:

Hi @nielsgerrits, yes it's possible. Try this.

Text To Find: ^(.{10}).*
String: \1

0684Q00000ArJLtQAN.png

You beat me to it! :-)

Hi @nielsgerrits, yes it's possible. Try this.

Text To Find: ^(.{10}).*
String: \1

0684Q00000ArJLtQAN.png

Thanks! I knew it should be doable but gave up after a few tries.

 

You can use the regex replacement method. For example, this will truncate all attribute names to the first 10 characters:

Thanks for the effort!

 

Reply


Community Stats

30,470
Posts
115,705
Replies
38,288
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.