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.
Solved
How to let the BulkAttributeRenamer do substring?
+67Best answer by david_r
You can use the regex replacement method. For example, this will truncate all attribute names to the first 10 characters:
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- Best Answer
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
+67Hi @nielsgerrits, yes it's possible. Try this.
Text To Find: ^(.{10}).*
String: \1
+67You can use the regex replacement method. For example, this will truncate all attribute names to the first 10 characters: