How to get number on file exclude varchar?

kivale · February 28, 2019, 1:44am

hallo,
yould you guys help me?

im using bash script

i have file getnumber.csv

cat getnumber.csv 
234198
654639
eht4v4
453nbddme
43
455fr

i try this

 cat getnumber.csv  | sed 's/[^0-9]*//g'

but the result is :

but, i just want to get numer :

234198
654639
 43

nezabudka · February 28, 2019, 1:53am

Hi kivale,
try this

grep -x "[0-9]\+" getnumber.csv

kivale · February 28, 2019, 1:55am

thankyou nezaa!

nezabudka · February 28, 2019, 1:55am

strange file format "csv" you have

RudiC · February 28, 2019, 3:49am

How about

sed -n '/[^0-9]/!p' getnumber.csv

nezabudka · February 28, 2019, 5:44am

that's how!

sed '/[^0-9]/d' getnumber.csv