String to RowSet to use in a Loop

[smandadi]

Pseudo Code
Variable: myVar=abc,def,xyz
for each myVar
FTP
endfor

How can I achieve this.. I can use either of the loop options (Do, While or For), and the variable is under our control,
We can use Comma Seperated, or, If its not possible even XML would be fine..

Just need a way to manipulate loops using variables.....

[Support_Duane]

GoAnywhere does not currently (as of July 2010) allow string operations on variables, so you cannot pass in a string and use pieces of it in your loop. What you can do, however, is to place the values into separate records in a file, (any of the file types that GoAnywhere can read - Database, CSV, Fixed Width, Excel, XML) read that file, then set up a For Each loop based on the value in each record.