One Star

Comments in tFileInputDelimited

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.
6 REPLIES
Employee

Re: Comments in tFileInputDelimited

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

Re: Comments in tFileInputDelimited

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

Re: Comments in tFileInputDelimited

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

Re: Comments in tFileInputDelimited

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

Re: Comments in tFileInputDelimited

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

Re: Comments in tFileInputDelimited

You are welcome.