Talend community forum / Comments in tFileInputDelimited

mlamrani · 2008-03-12 17:55:11

Tags: [comment, context, delimited file, java]

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.

mhirt · 2008-03-12 21:42:31

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,

Volker Brehm · 2008-03-12 22:55:51

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

mlamrani · 2008-03-13 09:10:53

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

Volker Brehm · 2008-03-13 21:45:43

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

mlamrani · 2008-03-14 09:04:40

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.

Volker Brehm · 2008-03-14 09:17:57

You are welcome.

Announcement

Unanswered posts

#1 2008-03-12 17:55:11

Comments in tFileInputDelimited

#2 2008-03-12 21:42:31

Re: Comments in tFileInputDelimited

#3 2008-03-12 22:55:51

Re: Comments in tFileInputDelimited

#4 2008-03-13 09:10:53

Re: Comments in tFileInputDelimited

#5 2008-03-13 21:45:43

Re: Comments in tFileInputDelimited

#6 2008-03-14 09:04:40

Re: Comments in tFileInputDelimited

#7 2008-03-14 09:17:57

Re: Comments in tFileInputDelimited

Board footer