join a statement in file's end lines

[Christian Aguilar Varga]

Hi,
How Can I join a statement in file's end lines, as follows:

#cat report.txt
Are,200.1.2.3,lima,plata
Are,200.1.2.3,ica,oro
Are,200.1.2.3,trujillo,cobre
Are,200.1.2.3,lima,plata
Are,200.1.2.3,ilo,bronce
Are,200.1.2.3,huancayo,litio
Are,200.1.2.3,huanuco,sodio
Are,200.1.2.3,piura,plata
Are,200.1.2.3,moquegua,oro
Are,200.1.2.3,loreto,bronce

I want to get the following, (With word "peru" joined in each end line):

Are,200.1.2.3,lima,plata,peru
Are,200.1.2.3,ica,oro,peru
Are,200.1.2.3,trujillo,cobre,peru
Are,200.1.2.3,lima,plata,peru
Are,200.1.2.3,ilo,bronce,peru
Are,200.1.2.3,huancayo,litio,peru
Are,200.1.2.3,huanuco,sodio,peru
Are,200.1.2.3,piura,plata,peru
Are,200.1.2.3,moquegua,oro,peru
Are,200.1.2.3,loreto,bronce,peru

I need some recommendation.

Thank you.

[Patrick Wallek]

If you are in vi you can do:

:1,$s/$/,peru/g

[Steven Sim Kok Leong]

Hi,

Here's another way from the command line:

# sed 's/$/,peru/' report.txt > parsed_report.txt

Hope this helps. Regards.

Steven Sim Kok Leong