Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

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

You are welcome.

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-13 21:45:43

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

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

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,

mlamrani
2008-03-12 17:55:11

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.

Board footer

Powered by FluxBB