Shell Programming and Scripting

Hi

I have a file which is having following text. The file is in a tabular form with 5 fields. i.e field1, field2 ..... field5 are its columns and there are many rows in it say COUNT is the number of rows

Field 1 Field2 Field3 Field4 Field5
------- ------- ------ ------ ------
abs sddd wee dffsd ffsdf
wqe dqdd wdqd dwqd weqwq
wqew wede wedw ddwe ewdfw
ewew weew rrfff edff ferf

I want to use the above file in my shell script.
Using AWK i want to loop through all the lines of the above file in the shell script.

In each iteration of the loop i want the field 1,field 3 and field 5 values in my own variables VAR1, VAR2, VAR3 defined in the shell script.


Kindly provide me with the necessary code.

Code:

while read v1 v2 v3 v4 v5
do
echo $v1 $v3 $v5
done < file

Here is my code

#!/usr/bin/sh

while read v1 v2 v3 v4 v5 v6
do
echo "$v1 $v4 $v6"| awk ' { printf("%-40s%-40s%-40s\n",$v1,$v4,$v6,
) } '

done < file.txt
But i am getting following error messages

Syntax Error The source line is 1.
The error context is
{ >>> printf("%-40s%-40s%-40s\n",$v1,$v4,$v6,) <<<
awk: 0602-502 The statement cannot be correctly parsed. The source line is 1.
Syntax Error The source line is 1.
The error context is
{ >>> printf("%-40s%-40s%-40s\n",$v1,$v4,$v6,) <<<
awk: 0602-502 The statement cannot be correctly parsed. The source line is 1.


Kindly tell what should be done to get formatted output?
~

Code:

while read v1 v2 v3 v4 v5 v6
do
printf "%-40s%-40s%-40s\n" $v1 $v4 $v6
done < file

Hi i want the output of the following code as follows:

colname typename NOT NULL default current timestamp


But there seems to be some problem I am not getting the output as i want . Only half of the value of $DEFAULT is getting printed i.e "current". Kindly correct that

COLNAME="colname"
typename="typename"
DEFAULT="current timestamp"

echo "$COLNAME $TYPENAME NOT NULL default $DEFAULT"| awk ' { printf("%-40s%-40s%-4s%-4s%-40s%-40s\n"
,$1,$2,$3,$4,$5,$6) } '

Why are you using awk?

Code:

printf "%-40s%-40s%-4s%-4s%-40s%-40s\n" $COLNAME $TYPENAME NOT NULL default "$DEFAULT"

Since there is a space in DEFAULT, "timestamp" is taken as the seventh field

Hi anu


i want a format which is supported across all shells.

morever i want the output to be re-directed to a logfile.

Kindly guide.