unix

Shell Programming and Scripting
1

Hi friends,

I have on data file containing 3 coloums...........

like this.

**** ***** *****
*** ***** *****
*** ***** *****
12.36 13,27 22.16
**** ***** *****
**** ***** *****
**** ***** *****
**** ***** *****
12.35 32.46 34.56

now from the above file i want to write only where the 3 fields are not blank.

can i use awk command.......
plz give me sysntax/........

2

Do you mean to say the lines are empty..Then just delete the lines

sed '/^[ \t]*$/d' inputfile

or

sed '/^$/d' inputfile
3

the above command not working.....
do u know awk syntax.............
i want only which row has the data based on third coloum..

4 
awk 'NF==3' inputfile
5

thank u for reply.................
it not working......

actually my question is display the lines where field 3 is not blank.

so the output should like this....

23.12 78.34 22.1
17.68 65.34 24.5
21.78 70.87 26.8

please verify and let me know............

thank u
rajan

6

Try...

awk '$3+0!=0' file1

Or...

awk '$3!~/^*+$/' file1
7

So you don't want the "**" fields? only everything else? yes/no?
ie
grep -v "^" filename
23.12 78.34 22.1
17.68 65.34 24.5
21.78 70.87 26.8

8

Ygor !! will this work for a row which have row like

56.78 45.12 00.00 ??? I guess this row has data for all the field ?
it may be that the data for third field is zero and i think 0 is also value .

9

The second awk program will return all lines where $3 is not asterixes.

10

thank u ygor..
u r code is working fine...............