I want to read delimited files may be comma / pipe / tab / semicolon delimited which in turn get converted to KML. What is the best way to read those files? Is it possible to change field separator character of csv reader at runtime?
Cheers
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.
- 8394 replies
Hi,
you can try with the CSV reader, it will let you specify the delimiter character:
David
- 8394 replies
Oh, and to answer your second question: I do not think you can change this at runtime.
If you have a mix of delimiters, one solution could be to pre-process your file using a Text File reader/writer combo that uses e.g. one or more StringReplacers to homogenize your delimiters.
Look into the WorkspaceRunner to chain these two workspaces, if needed.
David