Change Delimiter

One Star

Change Delimiter

Data Prep seems to assume fields are comma delimited and lines are CRLF delimited.  How do I change that to support custom delimiters?  I am trying to read EDI files which are delimited with an asterisk for fields and tilde for lines.  Thanks.
Moderator

Re: Change Delimiter

Hi,
Data Prep detects automatically the field separator but in case the auto-detection doesn't come up with the appropriate field separator, you can perfectly change it in the UI. Click the top-left gear icon and select "Other" as separator:

Regarding the line separator, that is not editable right now - it is expected to be a CRLF or a LF.
Regards,
Gwendal
One Star

Re: Change Delimiter

Hi, 
in reference to the delimiter, I have a dataset that is UTF-8 and I select tab as the separator.  When exporting as CSV it uses a double quote " as the separator causing my job in Talend DI to blow up.  
Please advise if this error can be resolved. 
Dan

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads