group by in files :-)

hellsd · #1 (**permalink**) 06-21-2005

My file looks like:

X^~^12^d
X^~^19^d
Y^~^5^d
Y^~^10^d
Y^~^11^d
Z^~^14^d

I need a script that will "group by" the first field and Concatenate the values.

My output should be:

X^~^12,19^d
Y^~^5,10,11^d
Z^~^14~d

Does anyone have any idea ?

vino · #2 (**permalink**) 06-21-2005

Your post is on similiar lines to that of

shell script comparing files in a file

Check it out.

vino

hellsd · #3 (**permalink**) 06-21-2005

where the delimiter is ^ and if the concatenated field is not last.

Any idea ?

vgersh99 · #4 (**permalink**) 06-21-2005

something to start with:

nawk -f hell.awk file.txt

hell.awk:

Code:

BEGIN { FS=OFS="^" }
{
    arr[$1] = ($1 in arr) ? arr[$1] "," $3 : $3
}
END {
  for (i in arr)
    print i OFS "~", arr[i]
}

hellsd · #5 (**permalink**) 06-21-2005

you are the best

vgersh99 · #6 (**permalink**) 06-21-2005

Quote:

Originally Posted by hellsd

you are the best

take a number....
glad to be of help.

hellsd · #7 (**permalink**) 06-21-2005

Lets say the input file is:
ABC^1^~^data^x
ABC^2^~^data^x
ABC^3^~^data^x
DEF^4^~^data^y
DEF^4^~^data^z
DEF^5^~^data^y
DEF^5^~^data^z
DEF^6^~^data^z
DEF^6^~^data^y
XYZ^7^~^data^t

Now I would like to group couple of fields(field 2 and field 5)
My output should be:

ABC^1,2,3^~^data^x
DEF^4,5,6^~^data^y,z
XYZ^7^~^data^t

Notice that I would like to print all the line's fields.

Is it possible?

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to listout the files based on group by the date...?	psiva_arul	UNIX for Dummies Questions & Answers	3	04-21-2008 09:03 AM
Newly created files default group and write permissions	goldfish	UNIX for Dummies Questions & Answers	2	02-20-2008 06:39 PM
Recursive search for group or other writeable 'dot' files	maficdan	Security	5	02-14-2008 09:43 PM
Monkcast #12: IBM HW group OEMs Solaris to chagrin of SW group & a ... - ZDNet.com bl	iBot	UNIX and Linux RSS News	0	08-17-2007 04:30 PM
listing sequential files as one group...	kentm	UNIX for Advanced & Expert Users	1	01-24-2007 06:11 PM

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: