Shell Programming and Scripting

Hi, some help is highly appreciated, I want to de-group my data for statistical analysis. I made up some sample data, there shouldnt be repeated lines in the output. My data is in excel but I can make it tab-delimited text.

Code:

A B,C
A B,D,E
X Y
X Y,Z

Expected output

Code:

A B
A C
A D
A E
X Y
X Z

Try:

Code:

awk '{n=split($2,a,","); for (i=1;i<=n;i++) print $1,a[i]}' file | sort | uniq

Perfecto ! thank yous

If you don't care about the output order, the following should be more efficient:

Code:

awk -F '[ \t,]' '
{ for(i = 2; i <= NF; i++) o[$1"\t"$i] }
END { for(i in o) print i }' file

It also produces tab delimited output instead of space delimited output.

If your input file is tab delimited (instead of space delimited as in your sample input), you can change the first line of this script to:

Code:

awk -F '[\t,]]'

If the output does need to be sorted you can make bartus11's script more efficient by replacing sort | uniq with sort -u.