Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
denombrate
Hi, I have a text file formated as below: yannick 2 1 5 2 1 0 3 1 6 8 anna 0 0 0 0 0 0 1 0 0 0 paul 2 0 0 0 0 0 0 0 0 0 bob 3 1 0 2 3 6 4 8 6 4 holyanna 4 0 0 0 0 0 0 0 0 0 samantha 0 0 0 0 0 5 0 0 0 0 richard 0 1 0 0 0 0 0 0 0 0 fred 0 0 3 0 0 0 0 0 0 0 tony 1 0 0 0 0 0 0 0 0 0 steve 4 2 0... -
gawk mismatch
I don't know why but this code below used to perfom crosstab query (see crosstab with AWK question)returns mismatch (with printing duplicate lines) if I use gawk interpretor instead awk. My gawk version is: GNU Awk 3.1.4. what's wrong ? BEGIN { FS=OFS=";" } { if ( !($2 in cols) )... -
crosstab with AWK
Cross tabulations are statistical reports where you de-normalize your data and show results grouped by one field, having one column for each distinct value of a second field. This cross tabulations are usualy made using SQL language into dababase engine, but I want to fix it using a simple awk...
