Remove characters not 6 figs in length and whitespace

[maxcrook]

Hi I have a list of numbers as follows:

012345
45
023567

c00456

I need to remove any numbers that are not of 6 figures plus remove white space.Ive tried this but for some reason it doesnt work (for removing characters of 2figs)

sed '/^[0-9]\{2\}$/d' filename > otherfilename

Any ideas ?

 

[columb]

This worked for me

 egrep [0-9]{6} test.file | tr -d ' '>test.op

Columb Healy

 

[maxcrook]

THANK YOU THANK YOU THANK YOU THANK !
Finally.....

I owe you a beer !

 

[columb]

Note that my version picks up lines of 6 or greater numbers. Something along the lines of

tr -d ' ' < test.file | egrep "^[0-9]{6}$" > test.op

will get lines of exactly six numbers

Columb Healy