Login or Register to Ask a Question and Join Our Community


UNIX for Beginners Questions & Answers

How to get number on file exclude varchar?

Login to Discuss or Reply to this Discussion in Our Community

 
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:
kivale
# 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:
kivale
# 5  
Old 02-28-2019
How about

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

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

This User Gave Thanks to nezabudka For This Post:
RudiC
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