Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

Labels (2)
2 Replies
Anonymous
Not applicable
Author

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:
0683p000009MCY1.png
Regarding the line separator, that is not editable right now - it is expected to be a CRLF or a LF.
Regards,
Gwendal
Anonymous
Not applicable
Author

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