Shell Programming and Scripting

I have file like this

"copy table_name from filea.txt on node replace delimiter '|';"
"copy table_name from fileb.txt on node replace delimiter '|';"
"copy table_name from filec.txt on node replace delimiter'|';"
"copy table_name from filee.txt on node replace delimiter '|';"
"copy table_name from filed.txt on node replace delimiter '|';"
"copy table_name from filef.txt on node replace delimiter '|';"
"copy table_name from fileg.txt on node replace delimiter '|';"
"copy table_name from fileh.txt on node replace delimiter '|';"
"copy table_name from filei.txt on node replace delimiter '|';"
"copy table_name from filej.txt on node replace delimiter '|';"
"copy table_name from filek.txt on node replace delimiter '|';"
"copy table_name from filel.txt on node replace delimiter '|';"
.
.
.
.
100000 lines

I want to change the above pattern to
"
"copy table_name from filea.txt on node1 delimiter '|';"
"copy table_name from fileb.txt on node2 delimiter '|';"
"copy table_name from filec.txt on node3 delimiter'|';"
"copy table_name from filee.txt on node1 delimiter '|';"
"copy table_name from filed.txt on node2 delimiter '|';"
"copy table_name from filef.txt on node3 delimiter '|';"
"copy table_name from fileg.txt on node1 delimiter '|';"
"copy table_name from fileh.txt on node2 delimiter '|';"
"copy table_name from filei.txt on node3 delimiter '|';"
"copy table_name from filej.txt on node1 delimiter '|';"
"copy table_name from filek.txt on node2 delimiter '|';"
"copy table_name from filel.txt on node3 delimiter '|';"
.

I am trying to use sed command on this as follows

for i in {1..3}
do
sed -e"s/replace/$i/g" output.txt >> final_output.txt
done

but the above code gives me every single file with node 1 node , node 3 command i.e. for each copy command there are three copy command generated.

Please help me with this.

Try this:

Code:

awk '{ sub( "node", "node" ((NR-1)%3)+1, $0 ); print; }' input-file >output-file