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
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
you can try with the CSV reader, it will let you specify the delimiter character:
David
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