Question

Delimiter Character

  • 6 October 2014
  • 2 replies
  • 10 views

Hello,

 

 

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

2 replies

Userlevel 4
Hi,

 

 

you can try with the CSV reader, it will let you specify the delimiter character:

 

 

 

 

David
Userlevel 4
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

 

 

Reply