New Line character on Windows

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Bostonian
Premium Member
Premium Member
Posts: 33
Joined: Fri Nov 20, 2009 3:32 pm

Post by Bostonian »

Excellent. That works. Thank you, chulett.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Excellent. For posterity's sake and anyone who stumbles across this thread in the future, can you share what part of all that was the actual solution in your case? Thanks.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Bostonian
Premium Member
Premium Member
Posts: 33
Joined: Fri Nov 20, 2009 3:32 pm

Post by Bostonian »

Here is my design.

Execute_command --> UserVariable --> StartLoop --> Job_Activity.

EC runs the ls abc*.txt

UV runs Field(Convert(@FM, ",", Execute_Command_0.$CommandOutput), ",", 1, Count( Execute_Command_0.$CommandOutput,@FM))

SL uses the output of UV as counter

JA has 2 input parameters. In Param 1, I am populating the SL.Counter. Param 2 is populated as Field(StartLoop_Activity_8.$Counter,'-',2,1).

If my file name is abc-123_1.txt then
JA.Param1 = abc-123_1.txt
JA.Param2 = 123
Post Reply