Search Results

Wasn't too clear in the spec. Try awk -F, '
RES ~ "^" $1 FS {X=$1
sub (X FS, "")
RES=RES FS $0
next
}
{if (NR...

Hello Bobby_2000,
Following may also help you in same.

awk '{X[++q]=$1 FS $2 FS $3 FS $4 FS $5 FS $6 FS $7;k=1} {for(i=8;i<=NF;i++){j=(i==8)?++j:j;if(k%3==0){S=S FS $i;print X[j] FS S;S=""}...

Is the output TAB delimited only until field 7 and the rest with spaces or are all fields separated by TABs ?

Not the slightest attempt from your side? pity...
Try straightforwardawk '{for (i=8; i<=NF; i+=3) print $1, $2, $3, $4, $5, $6, $7, $i, $(i+1), $(i+2)}' file
AWA Divi DD01 None 1 2 Room AC...

Quoting Don Cragun: