Substring HELP!

Shell Programming and Scripting
1

Hi,

I am trying to do something which I thought was very simple but still being a beginner, has proved not to be.

Input:

val1 val2 val3 val4 val5 val6
.
.
.
etc

Desired Output:

Every row in which value of val6 is a number starting with 0.0 or contains a capital E. The input is in .tab format

Sample:

INPUT:

val1 val2 val3 val4 val5 0.123
val1 val2 val3 val4 val5 0.01456
val1 val2 val3 val4 val5 0.000123
val1 val2 val3 val4 val5 0.0123
val1 val2 val3 val4 val5 3.2E-52
val1 val2 val3 val4 val5 0.153
val1 val2 val3 val4 val5 1

OUTPUT:

val1 val2 val3 val4 val5 0.01456
val1 val2 val3 val4 val5 0.000123
val1 val2 val3 val4 val5 0.0123
val1 val2 val3 val4 val5 3.2E-52

I have tried various scripts, all gave me errrors or didn't stop running.

I've tried

#!/bin/bash

for f in input.tab
do
awk ' c==substr($6, 1, 3)
if c==0.0 || E
print c'
done

I know this doesn't work, and I really need help. That would be very appreciated. Thanks!!

2 
awk '$6~/E/ || $6~/^0.0/' filename
3

Wow, thank you. That was a very elegant solution.