I am new to automate and having a difficult time attempting to create a task to do the following:

I have a txt file with a list

• ex : 123456,
• 789101,
• 121314,

Need automate to read the file, then based on the comma (or line break) to separate the values so that I can then run a copy command based on that.

Ex.

read and copy file 123456.doc from d:there to c:here

read and copy file 789101.doc from d:there to c:here

Was able to remove the commas and keep just the values with line breaks but having an issue making it reading each separate value.

Any assistance is appreciated!

Hi Robert,

You can use the steps below as an example.

Once the data is in the variable and separated by line breaks, you can use the Loop List action, selecting New Line as the delimiter. The line will be stored in a variable, called varLine in the example, that is updated on each pass of the loop. You can then use the varLine variable as part of a File System move or copy action as shown in the example.

These steps were created in AutoMate 10.


Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMVARIABLE NAME="varLine" VALUE="" /> <AMVARIABLE NAME="varList">123456 789101 121314</AMVARIABLE> <AMLOOP ACTIVITY="list" LIST="%varList%" DELIMITER="new_line" RESULTVARIABLE="varLine"> <AMFILESYSTEM SOURCE="c:\Test\%varLine%.doc" DEST="d:\Test\*.*" /> </AMLOOP>

-------------------------

Justin Aucoin | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665