awk script help

shehzad_m · #1 (**permalink**) 11-24-2008

i have a file which looks like below

001259 HCART TLD 0 215 - 1 569953856 FULL
001405 HCART TLD 0 2 - 3 444650118 FULL/MPX
001473 HCART TLD 0 11 - 1 477960976 FULL/MPX
001484 HCART TLD 0 10 - 1 601812747 FULL/MPX
001498 HCART TLD 0 182 - 3 418481688 FULL/MPX
001500 HCART TLD 0 188 - 1 418912608 FULL/MPX

I want script output to show first col with colon delimited in a row and delete all other columns for example output should be like

001259:001405:001473:001484:001498:001500

chatwizrd · #2 (**permalink**) 11-24-2008

cat file.txt | awk '{printf $1":"}' | sed 's/:$//'

Franklin52 · #3 (**permalink**) 11-24-2008

Try this:

Code:

awk '{s=s?s":"$1:$1}END{print s}' file

shehzad_m · #4 (**permalink**) 11-24-2008

Quote:

Originally Posted by Franklin52

Try this:

Code:

awk '{s=s?s":"$1:$1}END{print s}' file

I am getting an

awk: syntax error near line 1
awk: illegal statement near line 1

Franklin52 · #5 (**permalink**) 11-24-2008

Quote:

Originally Posted by shehzad_m

I am getting an

awk: syntax error near line 1
awk: illegal statement near line 1

Use nawk or /usr/xpg4/bin/awk on Solaris.

shehzad_m · #6 (**permalink**) 11-24-2008

Thanks .

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Passing the values to the secondary script when it invoked by primary script	venu_eie	UNIX for Advanced & Expert Users	2	07-03-2008 07:10 AM
Passing the values to the secondary script when it invoked by primary script	venu_eie	Shell Programming and Scripting	1	07-03-2008 06:16 AM
create a shell script that calls another script and and an awk script	magikminox	Shell Programming and Scripting	0	06-26-2008 02:50 AM
help me in sending parameters from sqlplus script to unix shell script	Hara	Shell Programming and Scripting	2	01-29-2008 03:31 PM
Shell Script: want to insert values in database when update script runs	ring	Shell Programming and Scripting	1	10-25-2007 03:06 AM

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