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