I am trying to read from an Esri SDE and write to a shapefile, but the length of the attribute names are causing problems for the writer. I've tried using AttributeRenamer to manually make all the attribute names under 10 characters, but is there any other way to address this problem? I'm using FME 2014.
Question
How to shorten attribute names?
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.
Hi @kevwin, I think that the SHAPE writer will shorten long attribute names automatically, if you apply Dynamic Schema option to the writer. See this article to learn more about dynamic schema: Basics of Dynamics (and related articles linked in this page).
If the dynamic schema option cannot be applied to your workspace for any reason, the SchemaMapper could be a better solution than the AttributeRenamer.
+46- Influencer
In 2015 you can use the BulkAttributeRenamer to shorten names to 10 characters using some regular expression replacement
Text to find:(?<=^.{10})(.*)
String:
However, this doesn't appear to work for me in 2014, although the option for Regular Expression replacement appears to be there.