print out columns

[krava]

hi,

I would like to write out certain columns (number is not fixed) from datafile. My program starts like:


echo "chose columns separated by commas";
read col;
awk -v c=$col 'BEGIN{
search=",";
n=split(c,a,search);
for (i=1;i<=n;i++) {
print a;
}}{......}' dataFile.dat > newDataFile.dat


If for exapmple col="3,6,9" then just these 3 columns of dataFile.dat are ptinted out into newDataFile.dat; If col="2,4,7,3,66,7" then these 6 columns are printed out.

How to print out variable number of columns in awk?


k.

 

[fpmurphy]

#!/bin/ksh
Try the following (a modified verion of your script)

read col?'Choose columns separated by commas: '
awk -v c="$col" -f awkfile datafile.dat

where awkfile contains

BEGIN {
     nCol = split(c, aCol, ",")
}

{
  for (i=1; i <=nCol; i++)
    printf("%s%s", $aCol[i], (i==nCol) ? ORS : OFS)
}

 

[krava]

thanks for reply...works fine

 

[vgersh99]

BEGIN {
nCol = split(c, aCol, ",")
}

{
for (i=1; i <=nCol; i++)
printf("%s%s", $aCol, (i==nCol) ? ORS : OFS)
}

Hmmm..... This reminds me of a solution at the other forum.

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+