topic Change Delimiter in Data Quality

Change Delimiter

Anonymous — Sat, 16 Nov 2024 10:13:29 GMT

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.

Re: Change Delimiter

Anonymous — Tue, 06 Dec 2016 08:40:10 GMT

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

Re: Change Delimiter

Anonymous — Wed, 08 Feb 2017 17:37:16 GMT

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