topic Re: Comments in tFileInputDelimited in Talend Studio

Comments in tFileInputDelimited

Anonymous — Sat, 16 Nov 2024 14:25:51 GMT

Hi,
Is it possible to include comment lines in a tFileInputDelimited ?
I actually use it to load a tContextLoad and I want to put some comments on the values given.
Thanks.

Re: Comments in tFileInputDelimited

Anonymous — Wed, 12 Mar 2008 20:42:31 GMT

I don't think it's very easy with comment line.
My advice is to use a comment column
Your file would be
key;value;comment
key1;value1;comment1
You can read only key and value columns with your tFileInputDelimited before your tContextLoad
Regards,

Re: Comments in tFileInputDelimited

Anonymous — Wed, 12 Mar 2008 21:55:51 GMT

What would you like to do? Just ignore the comments? How do you know its a comment (line starting with "#" for example)?
In this case you may use a filter.
Please give us some more information to help you.
Bye
Volker

Re: Comments in tFileInputDelimited

Anonymous — Thu, 13 Mar 2008 08:10:53 GMT

Exactly Volker, I just want to describe the key and value of the tFileInputDelimited, the comments should be ignored.

Re: Comments in tFileInputDelimited

Anonymous — Thu, 13 Mar 2008 20:45:43 GMT

Can you please give us an example of your input data.

Re: Comments in tFileInputDelimited

Anonymous — Fri, 14 Mar 2008 08:04:40 GMT

Here is a sample of the csv file, I used a comment column and it is ignored by the tContextLoad:
mysql_host;0.0.0.0;MySQL IP adress
mysql_port;3306;MySQL Port
mysql_db;talend;MySQL database name
mysql_user;talend;MySQL user
mysql_pass;talend;MySQL Password
...
It works perfectly now. Thanks.

Re: Comments in tFileInputDelimited

Anonymous — Fri, 14 Mar 2008 08:17:57 GMT

You are welcome.