One Star

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
4 REPLIES
One Star

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

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
One Star

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

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.
ThanksSmiley Happy
Ashish
One Star

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

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
One Star

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

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