Being new to this area .I have been assigned a task which i am unable to do . Can any one please help me .

Hi I have requirement where i have input file XYZ_111_999_YYYYMMDD_1.TXT and with header and series of Numbers and Footer.

I want to create a mutiple output files with each file having a seperate code which is stored in text file and create XYZ_222_999_YYYYMMDD_1.TXT . and add date in the contents next to series of numbers .Like this

Before change the file looks like this

file name XYZ_111_999_YYYYMMDD_1.TXT

001,19SEP2009-14:05:05,000000003
1234
4567
6785
END_OF_DATA

Output file should be as below

XYZ_222_111_YYYYMMDD_1.TXT where 222 will be from stored list or text file

001,222,19SEP2009-14:05:05,000000003
1234,19SEP2009-14:05:05,222
4567,19SEP2009-14:05:05,222
6785,19SEP2009-14:05:05,222
END_OF_DATA


List file will be as below

test.txt
222
333
444
555
666

First, your question is confusing. Do you want the results to be like test.txt, or as in XYZ_222_111_YYYYMMDD_1.TXT? They have different outputs, which are you wanting? And what are you writing this program in?

Also, post what you've written, and we can help you with it. But we're not going to write your programs for you.

@TB0ne: He wants the 2nd format, the test.txt is supplying the new values which are being added in to create the new files. Look at where '222' occurs in the 2nd file.


@OP:I agree, show us what you have done so far and we'll help.

That's what I thought, but wasn't sure....

TBH, that's just my interpretation ...