awk and array

[Rdave]

Hi all,

I am new to awk command I have the following input file:

rashmi:xyz@1234:zyx:1234;
prashant:xyz@2345:zyx:2345;

and I would like the output in this format:

rashmi prashant
xyz@1234 xyz@2345
zyx zyx
1234 2345

any ideas how to achive using awk.

I have managed to produce

rashmi
xyz@1234
zyx
1234

prashant
xyz@2345
zyx
2345

thanks in advance

 

[vgersh99]

something like that:

nawk -f columns.awk file.txt

#----------------- columns.awk
BEGIN {
FS=":|;"
}

{
for(i=1; i < NF; i=i+2) {
names[i, FNR]=$i
values[i, FNR]=$(i+1)
}
columns=int(i/2);
}

END {
for(i=1; i <= FNR*columns; i=i+columns) {
for(j=1; j <= columns; j++)
printf(&quot;%s\t&quot;, names[i,j] );
print &quot;&quot;
for(j=1; j <= columns; j++)
printf(&quot;%s\t&quot;, values[i,j] );
print &quot;&quot;
}
}
vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+