Shell Programming and Scripting

Hi ,

I have a file having around 8 columns spereated by space . Now that I need to extract columns from this. The problem is this functionality is needed in a script and the required columns are dynamic and can range from 2 columns to 8 columns at a time .

What I tried without luck is
If I could get the required column numbers in a variable in the below format
var_col="1\" \"\$2\" \"\$3"

awk -v awkvar=$var_col '{print $awkvar}'

here I expected to print the 1st,2nd and 3rd cols seprated by a space.But this did not work.


Can somebody help me out here please ?

Please provide sample data and expected output.

name1 yes no yes test test2
name2 no no yes prod test3


so if the request comes to get 1st , 5th and 2nd in sequence then the o/p should be

name1 test yes
name2 prod no


And here the col request are dynamic , it keeps changing acording to the scenarios

Like that we can see what you need.

Code:

awk '{print $1" "$5" "$2}' your.file

Thats correct , but here we manually never know its 1st , 5th & 2nd cols to be extracted , so i will need this to be put it in the variables and use those variables in awk , how can we do that ?

Try...

Code:

cols='$1,$5,$2'
awk '{print '$cols'}' file1

Yep That worked , Great Thanks for all the help