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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to use Chr(31) as field separator and Chr(30) as record separator?

I am trying to create "File Delimited" metadata and In the input file fields are delimited (separated) by ASCII Chr (31) and records are terminated (separated) by ASCII Chr (30).
Please Help!!! I am new to talend.
Thanks
Labels (2)
4 Replies
Anonymous
Not applicable
Author

Without taking a look on the code of the component and testing:
You could try
(char)31 
// or if this does not work try
((char)31).toString()

Bye
Volker
Anonymous
Not applicable
Author

Thanks Volker...
It worked (""+ (char)31). However, I have 5 columns in the input file but, in the preview panel it is showing only one column.
Thanks 0683p000009MACn.png
Ashish
Anonymous
Not applicable
Author

You are welcome.
By the way, sometimes there seems to be a difference between the preview and the real handling in the job. So I normaly do not use the preview...
Bye
Volker
Anonymous
Not applicable
Author

You are welcome.
By the way, sometimes there seems to be a difference between the preview and the real handling in the job. So I normaly do not use the preview...
Bye
Volker

Thanks Volker