hiteksoftware.com Forum Index hiteksoftware.com
User discussion forum
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Reformatting the Filenames variable

 
Post new topic   Reply to topic    hiteksoftware.com Forum Index -> Monitoring Tasks
View previous topic :: View next topic  
Author Message
Robert
Site Admin


Joined: 25 May 2006
Posts: 1140

PostPosted: Wed Dec 19, 2012 9:48 pm    Post subject: Reformatting the Filenames variable Reply with quote

User email support request:

I have the task set up in a chain with an email task after it. Everything is running great and sending an email when the task finds modified files. In the email task I have placed the “TaskTitle::Filenames” variable in the email body to give a list of files. Is there an easy way to format this list in a single column of filenames rather than one continuous line of text? I thought of maybe using the Manipulate Variable task to change the “^#” in the output to a CRLF but I’m not sure it’s possible to do that.
Back to top
View user's profile Send private message
Robert
Site Admin


Joined: 25 May 2006
Posts: 1140

PostPosted: Wed Dec 19, 2012 9:49 pm    Post subject: Reply with quote

1) Changing ^# to CRLF or \n will not work using the Manipulate variable task because the data files are property files (one property per line) .
2) You could change it to ,[space].
3 You can also try using the Arrays / Filename to Array task. This will put them in a single column. Then use the array variable in your email task.
Back to top
View user's profile Send private message
Robert
Site Admin


Joined: 25 May 2006
Posts: 1140

PostPosted: Thu Dec 20, 2012 9:11 am    Post subject: Reply with quote

user reply:

The Filename to Array task looks perfect. The only problem I’m having is on the email, when I call the array it’s returning “null”. I’m using the variable as $%ARRAY--BigYFTP--Filenames%$ and when I check the variable data under menu Variables|Task Variables, all the data shows correct. Is there a different syntax for calling an array variable?
Back to top
View user's profile Send private message
Robert
Site Admin


Joined: 25 May 2006
Posts: 1140

PostPosted: Thu Dec 20, 2012 9:12 am    Post subject: Reply with quote

This is the format to use:
$%ARRAY--BigYFTP--Filenames::ALLROWS%$

Documentation:
$%ARRAYNAME::FIRSTROW%$
$%ARRAYNAME::LASTROW%$
$%ARRAYNAME::ALLROWS%$
$%ARRAYNAME::FIRSTCELL%$
$%ARRAYNAME::LASTCELL%$
$%ARRAYNAME::ROW::rownumber%$
$%ARRAYNAME::CELL::rownumber::columnnumber%$

example: $%ARRAY--taskTitle--variable::FIRSTROW%$
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    hiteksoftware.com Forum Index -> Monitoring Tasks All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group