Re^2: join column 3 for unique values

How do I print column 4 and col 5 data, if there are more then 3 columns</p

Comment on Re^2: join column 3 for unique values

Replies are listed 'Best First'.
Re^3: join column 3 for unique values by kevbot (Vicar) on Sep 06, 2016 at 05:17 UTC
I'm not sure that I understand your request. The script in my earlier reply (Re: join column 3 for unique values) will work with additional columns in the data file. For example, if data.txt contains this `A1 abc yellow 1 abc B1 xyz green 2 def A2 cde red 3 ghi A1 abc green 4 jkl A2 cde yellow 5 mno A1 abc blue 6 pqr` [download] the output will be `A1 abc yellow:green:blue 1:4:6 abc:jkl:pqr A2 cde red:yellow 3:5 ghi:mno B1 xyz green 2 def` [download]	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: join column 3 for unique values
by kevbot (Vicar) on Sep 06, 2016 at 05:17 UTC

data.txt

A1 abc yellow 1 abc
B1 xyz green 2 def
A2 cde red 3 ghi
A1 abc green 4 jkl
A2 cde yellow 5 mno
A1 abc blue 6 pqr
[download]

A1 abc yellow:green:blue 1:4:6 abc:jkl:pqr
A2 cde red:yellow 3:5 ghi:mno
B1 xyz green 2 def
[download]