Shell Programming and Scripting

Hi Guys,
I am using following code to do some task.
Can somebody please help me to use a for loop for this ?

___________________________________________________

sed s/DATA2/`awk '/ / {print $1}' formated1`/ EOD_Batch > EOD_Batch1
sed s/DATA3/`awk '/ / {print $2}' formated1`/ EOD_Batch1 > EOD_Batch
sed s/DATA4/`awk '/ / {print $3}' formated1`/ EOD_Batch > EOD_Batch1
sed s/DATA5/`awk '/ / {print $4}' formated1`/ EOD_Batch1 > EOD_Batch
sed s/DATA6/`awk '/ / {print $5}' formated1`/ EOD_Batch > EOD_Batch1
sed s/DATA7/`awk '/ / {print $6}' formated1`/ EOD_Batch1 > EOD_Batch
sed s/DATA8/`awk '/ / {print $7}' formated1`/ EOD_Batch > EOD_Batch1
sed s/DATA9/`awk '/ / {print $8}' formated1`/ EOD_Batch1 > EOD_Batch
sed s/DATA10/`awk '/ / {print $9}' formated1`/ EOD_Batch > EOD_Batch1
sed s/DATA11/`awk '/ / {print $10}' formated1`/ EOD_Batch1 > EOD_Batch
sed s/DATA12/`awk '/ / {print $11}' formated1`/ EOD_Batch > EOD_Batch1
sed s/DATA13/`awk '/ / {print $12}' formated1`/ EOD_Batch1 > EOD_Batch
sed s/DATA14/`awk '/ / {print $13}' formated1`/ EOD_Batch > EOD_Batch1
sed s/DATA15/`awk '/ / {print $14}' formated1`/ EOD_Batch1 > EOD_Batch
sed s/DATA16/`awk '/ / {print $15}' formated1`/ EOD_Batch > EOD_Batch1
______________________________________________________________

Any Sample input and Sample output??

Thanks for going through ..

What I am trying to do is ...

File 1) EOD_Batch
DATA2
DATA3
...
...
DATA16


Replace the records with values from file formated1

File 2) formated1
10 20 30 ..150


so that at the end EOD_Batch should be
10
20
30
...

..
150


--------------

In the file EOD_Batch , purposely I am not starting from DATA1 ..because if I replace DATA1 with some value ..it will also replace DATA11 as

DATA11= 'DATA1'1.

I could also create EOD_Batch1 , EOD_Batch2 , EOD_Batch3 ...after every replacement but then I need to delete 14 files ( EOD_Batch2 ..15 ) .
Off course ,if we are applying for loop that will be easier ...


I am looking for something like this

for i in 2,3,4,5,6,7,8,9,10,11,12,13,14,15,16
do
sed s/DATA($i)/`awk '/ / {print $($i-1)}' formated1`/ EOD_Batch > EOD_Batch($i)
done

Hope this will help....

Regards..

For what i see as your output, are you trying to put the text from file formated1 to rows?
If so this should help :
awk 'gsub(/ /,"\n") {print}' a.txt

Please provide a clearer example of what the input / output looks like