Search Results

awk:
gawk '{
if(NR==FNR){
_[$1]=$2
}
else{
if(/Storage/){
name=$NF
}
else{
if(NF==2){
l[name]+=_[$2]...

A simpler version without adaptive column widths:
awk '
$1=="for"{
A[I=$2]
next
}
NF{
if($1 in A){
sub(ORS, T[$1]+$2 ORS, A[$1])
printf "%s",$1 A[$1]
}
...

Hi jpkumar10,
I think I have something that works, but the spacing is different (making the computed 4th column values line up with the end of the heading for that column) and I disagree with the...

awk '$1{gsub(/\n/," ");print RS$0}' RS="name" infile

awk '{if(/name/){printf "\n%s ",$0;} else{ printf "%s ",$0;}} END {printf "\n";}' filename

NOTE: these solutions are GNU only, nothing wrong with that, but this will not work on every platform...

See if this helps :


awk '{gsub("[0-9][0-9]","&:",$1);sub(":$","",$1) }1 ' input


Regards
Peasant

awk 'BEGIN{FIELDWIDTHS="2 2 2 2 2 2 2 7"}{OFS=":"; print $1,$2,$3,$4,$5,$6,$7 $8}' infile

[root@dist unix]# sed 's/../&:/g;s/://7g' file
21:00:00:12:34:34:56 asdf
21:00:00:12:34:34:78 asd3
21:00:00:12:34:34:23 asdf
21:00:00:12:34:34:45 asdf
21:00:00:12:34:34:89 asdf

Try this:
awk -F":" '/name/{s=$2;next} /id/{s=s "/" $2;next} {print $1 OFS s}' file

awk 'NR==FNR{a[$1]=substr($0,length($1)+2);next}{if(a[$3]){print $0,a[$3]}}' file2 file1
--ahamed

awk 'NR==FNR{a[$1]=$0;next} {print $0, $3 in a?a[$3]:"some crap"}' file_2 file_1

Something like this?
awk 'NF==2{h=$1; array[h]=$2; next}{array[h]=array[h] "," $1} END{for(i in array)print i "=" array[i]}' file