topic split list of files stored in variable in Talend Studio

split list of files stored in variable

Anonymous — Tue, 12 Jan 2016 12:45:35 GMT

Hi

I'm storing all files in a context variable and then passing that variable to tsendmail to get list of files.

But in list I have two types of file, one is "A.xls.b" and second is "A.xls.g"

but when I pass variable in tsendmail, I get output like

Files: A.xls.b, A.xls.g

But I need files like

B Files: A.xls.b
G Files: A.xls.g

Can I get any suggestion ?

Re: split list of files stored in variable

Anonymous — Tue, 12 Jan 2016 14:55:34 GMT

Files: A.xls.b, A.xls.g

Is this a string you write in the message field of tSendMail?

Re: split list of files stored in variable

Anonymous — Tue, 12 Jan 2016 16:02:24 GMT

Hi Shong

In message filed of tsendmail I pass only only context variable in which I'm storing list of all files.
https://www.talendforge.org/forum/img/members/155571/mini_blob_20160106-1535.png

After taggregaterow component, In my job am using tjavarow component. In that component I have put up that context variable.

In tfilelist, I have two types of files like I said one type is "A1.xls.b" and second is "A2.xls.g"

I want to send email, list of these files should be appeared in received mail like this

b Files: A1.xls.b
g Files: 2.xls.g

Not Like this:
Files: A2.xls.g, A1.xls.b (Note: this type of input I'm receiving right now cos I have set up a context variable "Files" with datatype list and value "Files : " in context.)

And In tjavarow, code written is context.Files = context.Files+input_row.ColumnName

But I need out like I said.

Any suggestion ?

Re: split list of files stored in variable

Anonymous — Tue, 12 Jan 2016 16:50:12 GMT

Are you wanting to attach the files you have named in your context variable or do you just want to list the filenames as you have shown above? This needs to be clarified. If you want to just list the filenames in the email message, then you will need to prepare the context variable to hold the values already formatted (using carriage returns, etc). If you are wanting to attach the files using the names, then I think you need to rethink your solution a little.

Re: split list of files stored in variable

Anonymous — Tue, 12 Jan 2016 17:20:48 GMT

I just need the name of the files in message with the format I have mentioned.

Re: split list of files stored in variable

Anonymous — Tue, 12 Jan 2016 22:38:52 GMT

OK, try something like this.
Edit your context variable to add this ("\r\n") between your filenames. So, as a simple example, if you wanted to manually create a String with the filenames in, you would do it something like below.....

context.Files = "b Files: A1.xls.b" + "\r\n" + "g Files: 2.xls.g" + "\r\n" + "c Files: 3.xls.c";

Re: split list of files stored in variable

Anonymous — Wed, 13 Jan 2016 02:43:04 GMT

Hey rhall

context.Files = "b Files: A1.xls.b" + "\r\n" + "g Files: 2.xls.g" + "\r\n" + "c Files: 3.xls.c";

Its a output am receiving through email when I pass parameter in tsendmail. At tjavarow component I have to split I think.

Re: split list of files stored in variable

Anonymous — Wed, 13 Jan 2016 09:28:34 GMT

It doesn't matter where you try out the code I have posted, just do it before you try and use the context variable. There is no guarantee it will work, but that is the first thing I would try.