Awk command

sakthifire · #1 (**permalink**) 03-19-2009

Hi
I have a input file like the below:

V1^a,b
V1^a
V2^b,c
V1^a,b,c
V2^c,d
V3^e,a,f

I want the output file like the below.

V1^a
V1^b
V1^a
V2^b
V2^c
V1^a
V1^b
V1^c
V2^c
V2^d
v3^e
V3^a
V3^f

I want the output file to be shown using awk command .

Regards
Sakthifire

Shahul · #2 (**permalink**) 03-19-2009

hi,

Code:

$ cat inputfile |tr '^' ','|awk -F, 'OFS="^" {if(NF>2) {{print $1,$2}  {print $1,$3} {print $1,$4}} else {print $1,$2}}'|awk -F"^" '{if($2 != "") print }'
V1^a
V1^b
V1^a
V2^b
V2^c
V1^a
V1^b
V1^c
V2^c
V2^d
V3^e
V3^a
V3^f

Thanks
Sha

sakthifire · #3 (**permalink**) 03-20-2009

Thank you Sha ...
Its working.

Sakthifire

cfajohnson · #4 (**permalink**) 03-19-2009

Code:

awk -F^ '{n = split( $2,a,",")
for ( x = 1; x <= n; ++x ) printf "%s^%s\n", $1, a[x]
}' FILENAME

Franklin52 · #5 (**permalink**) 03-19-2009

Another approach:

Code:

awk 'BEGIN{ FS="[,^]" } { for(i=2;i<=NF;i++) print $1"^"$i }' file

Regards

summer_cherry · #6 (**permalink**) 03-19-2009

Code:

nawk -F"^" '{
	num=split($2,arr,",")
	for(i=1;i<=num;i++)
		print $1"^"arr[i]
}' filename

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
problem with output of find command being input to basename command...	new_learner	UNIX for Dummies Questions & Answers	2	12-14-2008 02:56 AM
awk/sed Command : Parse parameter file / send the lines to the ksh export command	rajan_san	Shell Programming and Scripting	4	11-06-2008 01:29 PM
assign a command line argument and a unix command to awk variables	sweta_doshi	Shell Programming and Scripting	0	08-08-2008 06:54 AM
Help Required: Command to find IP address and command executed of a user	loggedout	Security	2	08-06-2008 08:12 PM
inconsistent ls command display at the command prompt & running as a cron job	rajranibl	SuSE	5	07-30-2007 08:26 AM

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:


	Powered by