I'm trying to write a CSV file with leading and trailing spaces in the field/column names. I know this is unusual, but is required for a specific deliverable. The feature writer transformer does not appear to allow this. Any ideas on how best to accomplish this?
Question
Writing CSV file with leading and trailing spaces in the field 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.
I was able to make it work by importing the feature type definition from an existing CSV with spaces in the column names.
+10- Contributor
Thanks for the quick response. I'm not really sure how to implement that solution, but I'll try it.
+46- Influencer
You could also just choose not to write the field names in the writer, and send a record which contains the field names including spaces as the first record to write.
+10- Contributor
Thanks to all for your help. Turns out I was making a simple mistake, which resulted in a problem that should not have been a problem. It is simple to add the white space in the writer itself by using the "Manual" radio button under the "User Attributes" tab. When I did that, I inadvertently forgot to update the "Value" field on the right-hand side to the pane to correspond with the correct source field, which at this point does not automatically match due to adding the white space manually.