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.