I have the following data. I can imagine doing this in loop but would take lot of time as there are many records. Is there any quick way of doing this in datastage? I know this can be acheived using shell. As i am poor in shell I want to see if this can be done in DS. Any help is greatly appreciated.
Code: Select all
order File_name
7222245 7222245.pdf
7222245 7222245a.pdf
7222245 7222245b.pdf
7222245 7222245c.pdf
7222245 7222245d.pdf
7222250 7222250.pdf
7222250 7222250a.pdf
7222250 7222250b.pdf
Code: Select all
For example output for above set is :
7222245.txt
>>7222245.pdf
>>7222245a.pdf
>>7222245b.pdf
>>7222245c.pdf
>>7222245d.pdf
------------------------------------
7222250.txt
>>7222250.pdf
>>7222250a.pdf
>>7222250b.pdf
-------------------------------------