How to get number on file exclude varchar?


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers How to get number on file exclude varchar?
# 1  
Old 02-28-2019
How to get number on file exclude varchar?

hallo,
yould you guys help me?

im using bash script

i have file getnumber.csv
Code:
cat getnumber.csv 
234198
654639
eht4v4
453nbddme
43
455fr

i try this
Code:
 cat getnumber.csv  | sed 's/[^0-9]*//g'

but the result is :
Code:
234198
654639
4v4
453
43
455


but, i just want to get numer :
Code:
234198
654639
 43



Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!

Last edited by RudiC; 02-28-2019 at 04:47 AM.. Reason: Added (and changed to) CODE tags.
# 2  
Old 02-28-2019
Hi kivale,
try this
Code:
grep -x "[0-9]\+" getnumber.csv

This User Gave Thanks to nezabudka For This Post:
# 3  
Old 02-28-2019
thankyou nezaa!
# 4  
Old 02-28-2019
strange file format "csv" you have Smilie
This User Gave Thanks to nezabudka For This Post:
# 5  
Old 02-28-2019
How about

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

This User Gave Thanks to RudiC For This Post:
# 6  
Old 02-28-2019
that's how!
Code:
sed '/[^0-9]/d' getnumber.csv

This User Gave Thanks to nezabudka For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find and exclude what is in file

Hello everyone, I try to find folders older than 3 years and display them, but excluding some directories, the below code does NOT exclude listed directories: find . -maxdepth 3 -mtime +1095 -type d -exec ls -l {} \; | grep -vFf oldExclude >> older oldExclude Folder1/ Folder2/... (7 Replies)
Discussion started by: Abu Rayane
7 Replies

2. Shell Programming and Scripting

Exclude variable from a file

Hello, I have a list of patterns which I'd like to exclude from a file. I tried to do while read line do grep -v $line file >> new.file done < mylist But obviously it won't work. It only works for just grep. I know I can do: grep -Ev 'pattern1|pattern2|...' myfile but my... (7 Replies)
Discussion started by: coppuca
7 Replies

3. UNIX for Dummies Questions & Answers

Exclude file with tar

hi, i am trying to use a exclude file to exclude some file directories while making a tar archive. This is my command: tar -pcvf orahome10gR2.tar.gz db_1 -X /home/oracle/excludeFile.txt /home/oracle/ when i execute it, it seem to be tar-ing. But once is done, i cd to /home/oracle and could... (2 Replies)
Discussion started by: redologger
2 Replies

4. Shell Programming and Scripting

Exclude a file or not in

Hi Gurus. I have a directory and i receive many files with extension .log. I processed the file as i get it. i want to process all the files except one which i know i don't want to process. cd /backup/temp/rajesh/PACS #--- directory , under this i have below files... (1 Reply)
Discussion started by: guddu_12
1 Replies

5. Ubuntu

[Solved] Using Find with an exclude/exclude file

I am familiar with using tar and exclude/include files: tar zcf backup.dirs.tgz --files-from=include.mydirs --exclude-from=exclude.mydirs --no-recursion but was wondering if I could use find in the same way. I know that you can just specify the directories to exclude but my list is... (2 Replies)
Discussion started by: metallica1973
2 Replies

6. Shell Programming and Scripting

Have to exclude the first and last line of the file : help me

hi , i am very new to perl . scriptting.. pllease can any one help me ...pleaseeeeeee i ll have a file which look likes 123 |something |567 456 |welcome |789 457 |inboxpost |790 . . 123 |something |567 i have to execute all the lines in the file except the first and the... (14 Replies)
Discussion started by: vishwakar
14 Replies

7. Shell Programming and Scripting

ls to exclude file

I have cgicsave.env and cgic*, but I want to print cgic* value but NOT cgicsave.env Thanks (9 Replies)
Discussion started by: xs2punit
9 Replies

8. Shell Programming and Scripting

How to exclude certain colomn from the file?

Hi I have a file in the following format: 4135 f4135acc: 39798 rmtdb: 0 /t1/data/f4135acc.dta 4135 f4135pdb: 39795 rmtdb: 0 /bb/data/f4135pdb.dta 4135 p4135eng: 0 rmtdb: 0 /bb/bin/p4135eng 4135 r4135eng: 14142 rmtdb: 0 ... (6 Replies)
Discussion started by: aoussenko
6 Replies

9. UNIX for Advanced & Expert Users

sorting of varchar columns

Hi , I need to sort a file based on multiple columns All the columns are of varchar type can any one give me the command to sort for varchar columns? Thanks (3 Replies)
Discussion started by: laxmi131
3 Replies

10. UNIX and Linux Applications

Mysql CHAR vs VARCHAR

Looking for any advise from a DBA/DA. When should you use CHAR and when should you use VARCHAR when designing a table. From my readings seems like VARCHAR will accept any length string even though you define a length to it, so I setup gadget VARCHAR(10) I could actually put something with 20... (1 Reply)
Discussion started by: benefactr
1 Replies
Login or Register to Ask a Question