09-21-2006
How to remove all lines with something other than numbers
Hi,
How would I get rid of lines having something else than numbers (such as tabs,white space, special characters, empty line, letters).
So I have big file with numers as follows:
12345678901
23456789012
32343678901
42345638901
52345678901
and I sometimes the file might contain some stuff not belonging there.
So if someone could help me with some nice one-liner to remove all lines that does not follow the format I want: 11 numbers and nothing else.
Thanks,
//Juha
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
Can I edit this script:
find . -type f | while read i;do && mv "$i" "${i//abc/}" ;done
so that it will not only take out abc from the filename but also take out any numbers that might be in the filename as well.
An example would be,
Input:
filename abc 2009.mov
Output:... (7 Replies)
Discussion started by: Monkey Dean
7 Replies
2. Shell Programming and Scripting
How can I remove the numeric (1,2,3,4,5,etc.) in front of each line? The file look like this..
1CREATE OR REPLACE pROD (p_sc_id number,
2 p_snap_id number , p_sid number, p_halt varchar2 default 'N', p_a_nm varchar2 )
3 as
4 v_rtn number;
5
6 v_rtn... (3 Replies)
Discussion started by: Beginer0705
3 Replies
3. Shell Programming and Scripting
Hi,
I am trying to cleanup 7 or 10 digits numeric from the file. So for example :
Input :
3M Corporation
3M Inc. 888-356-8765
3M Inc. 356-8765
3M Inc. 3568765
3M Inc. 356-8765
3M 8883568765 Inc.
Output :
3M Corporation
3M Inc. - -
3M Inc. -
3M Inc.
3M Inc. - (8 Replies)
Discussion started by: msalam65
8 Replies
4. Shell Programming and Scripting
lsps -s | awk '{print $1}'|tail -1
71680 MB
lsps -s | awk '{print $2}'|tail -1
2%
vmstat |grep lcpu |awk '{print $3}'
lcpu=8
I need to removt the MB % lcpu= from the outputs so they can show as
71680
2
8
respectively.
Please advise.
Thank you so much, (8 Replies)
Discussion started by: Daniel Gate
8 Replies
5. Shell Programming and Scripting
I have a file that has some text that looks like this
Some Text
1. More text
2. Different text
Final Text
I would like the remove the lines of text that start with the numbers.
Some Text
Final Text
I have tried to use cat file.txt | grep -Ev 1. >... (9 Replies)
Discussion started by: icculus99
9 Replies
6. Shell Programming and Scripting
Hello All,
I was wondering if someone might know how to do this. I have a word list that is format like the example below. I need to take away the :number after that... is there some kind of command I could use to remove them?
123456:5562
password:1507
123456789:989
qwerty:877... (7 Replies)
Discussion started by: 3therk1ll
7 Replies
7. Shell Programming and Scripting
how to remove all numbers from this.Using sed command
1. abcd123
2. 312jjs33 (17 Replies)
Discussion started by: rafa_fed2
17 Replies
8. Shell Programming and Scripting
Hi,
I have numerous files which have data in the following format
A|B|123.|Mr.|45.66|33|zz
L|16.|33.45|AC.|45.
I want to remove decimal point only if it is last character in a number.
O/p should be
A|B|123|Mr.|45.66|33|zz
L|16|33.45|AC.|45
I tried this
sed -e 's/.|/|/g'
Problem... (6 Replies)
Discussion started by: wahi80
6 Replies
9. UNIX for Beginners Questions & Answers
Hi,
I am trying to remove trailing zeros from numbers in a csv file.
CSV Input : 0.5000,abc,2.00,2.400,285.850,285a.850,205.180800,mno000,a0b0,2.860
Expected Output :
.5,abc,2,2.4,285.85,285a.850,205.1808,mno000,a0b0,2.86
Can you please help.
Thanks. (11 Replies)
Discussion started by: manubatham20
11 Replies
10. Shell Programming and Scripting
I have been searching and trying to come up with an awk that will perform the following on a
converted text file (original is a pdf).
1. Since the first two lines are (begin with) text they are removed
2. if $1 is a number then all text is merged (combined) into one line until the next... (3 Replies)
Discussion started by: cmccabe
3 Replies
LEARN ABOUT LINUX
anacrontab
ANACRONTAB(5) Anacron Users' Manual ANACRONTAB(5)
NAME
/etc/anacrontab - configuration file for anacron
DESCRIPTION
The file /etc/anacrontab describes the jobs controlled by anacron(8). Its lines can be of three kinds: job-description lines, environment
assignments, or empty lines.
Job-description lines are of one of these two forms:
period delay job-identifier command
@period_name delay job-identify command
The period is specified in days, the delay in minutes. The job-identifier can contain any non-blank character, except slashes. It is used
to identify the job in Anacron messages, and as the name for the job's timestamp file. The command can be any shell command. The fields
can be separated by blank spaces or tabs. The period_name can only be set to monthly at the present time. This will ensure jobs are only
run once a month, no matter the number of days in this month, or the previous month.
Environment assignment lines are of the form:
VAR = VALUE
Spaces around VAR are removed. No spaces around VALUE are allowed (unless you want them to be part of the value). The assignment takes
effect from the next line to the end of the file, or to the next assignment of the same variable.
Empty lines are either blank lines, line containing white-space only, or lines with white-space followed by a '#' followed by an arbitrary
comment.
You can continue a line onto the next line by ending it with a ''.
SEE ALSO
anacron(8)
The Anacron README file.
AUTHOR
Itai Tzur <itzur@actcom.co.il>
Currently maintained by Pascal Hakim <pasc@(debian.org|redellipse.net)>.
Pascal Hakim 2004-07-11 ANACRONTAB(5)