Script to append a value seperated by comma

Tuxidow · #1 (**permalink**) 08-24-2009

I have a file like below. How can I add a new value after moss separated by a comma. This adding script should work in such a way that each time i pass a value it should be added one after the other separated by commas.

Code:

hru:122:
hello:123:john,philip,mary,kp,moss
hi:124:
bye:125:

Can anybody please help me in this.

vgersh99 · #2 (**permalink**) 08-24-2009

depending on what you want to do, this might be one of them:

Code:

nawk -v val='foo' '!/:$/ {$0=$0 "," val}1' myFile

Tuxidow · #3 (**permalink**) 08-25-2009

thanks a lot for the reply!!

i want this to add only for "hello".. how to do that...? not generic..!! can anybody please help me to understand the above code too??

---------- Post updated at 10:46 PM ---------- Previous update was at 06:47 AM ----------

myfile

Code:

hru:122:
hello:123:john,philip,mary,kp,moss
hi:124:
bye:125:
hi:124:
bye:125:
hi:124:
bye:125:
tata:125:pipe,grep

How to modify the above script just to add the new value only to "hello" not for tata. Script should be some what like, search for hello and add the new value there. Each new values to be separated by a comma.. Sorry for not being so clear in my first post

So if the new value i have is foo, the modified file should be like this..

Code:

hru:122:
hello:123:john,philip,mary,kp,moss,foo
hi:124:
bye:125:
hi:124:
bye:125:
hi:124:
bye:125:
tata:125:pipe,grep

I modified the script like this..

Code:

awk -v val='foo' '!/:$/ {$0=$0 "," val}1' myfile > myfilenew
cat myfilenew > myfile
rm -rf myfilenew

bu the output im getting is like the following...

the new myfile

Code:

hru:122:
hello:123:john,philip,mary,kp,moss,foo
hi:124:
bye:125:
hi:124:
bye:125:
hi:124:
bye:125:
tata:125:pipe,grep,foo

It would be a great help if some one can help me in this.

Franklin52 · #4 (**permalink**) 08-25-2009

Have you tried to adjust the code?

Regards

Tuxidow · #5 (**permalink**) 08-25-2009

I am not so good in awk. hence not able to understand the above code...!! :-(. hence could not modify it... :-(

thanhdat · #6 (**permalink**) 08-25-2009

so, take a quick look at this link: 10 Awk Tips, Tricks and Pitfalls - good coders code, great reuse
hope that helps!

Tuxidow · #7 (**permalink**) 08-25-2009

I got it...!! Thanks for all your help...!!

Code:


awk -v val='foo' '/hello:123:/ {$0=$0 "," val}1' myFile

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
perl help for comma seperated output	namishtiwari	Shell Programming and Scripting	3	06-15-2009 05:21 AM
Removing blank lines from comma seperated and space seperated file.	pinnacle	Shell Programming and Scripting	11	05-08-2009 12:58 PM
change list to comma seperated items	insania	Shell Programming and Scripting	2	10-03-2007 06:21 PM
Comma Seperated List of Values	brap45	Shell Programming and Scripting	9	02-23-2006 05:12 AM
Handling .CSV( Comma seperated value) in awk	Laud12345	Shell Programming and Scripting	1	05-09-2005 05:41 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: