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
wc(1) General Commands Manual wc(1)
NAME
wc - Counts the lines, words, characters, and bytes in a file
SYNOPSIS
wc [-c | -m] [-lw] [file...]
The wc command counts the lines, words, and characters or bytes in a file, or in the standard input if you do not specify any files, and
writes the results to standard output. It also keeps a total count for all named files.
STANDARDS
Interfaces documented on this reference page conform to industry standards as follows:
wc: XCU5.0
Refer to the standards(5) reference page for more information about industry standards and associated tags.
OPTIONS
Counts bytes in the input. Counts lines in the input. Counts characters in the input. Counts words in the input.
OPERANDS
Specifies the pathname of the input file. If this operand is omitted, standard input is used.
DESCRIPTION
A word is defined as a string of characters delimited by white space as defined in the X/Open Base Definitions for XCU4.
The wc command counts lines, words, and bytes by default. Use the appropriate options to limit wc output. Specifying wc without options
is the equivalent of specifying wc -lwc. If any options are specified, only the requested information is output.
The order in which counts appear in the output line is lines, words, bytes. If an option is omitted, then the corresponding field in the
output is omitted. If the -m option is used, then character counts replace byte counts.
When you specify one or more files, wc displays the names of the files along with the counts. If standard input is used, then no file name
is displayed.
EXIT STATUS
The following exit values are returned: Successful completion. An error occurred.
EXAMPLES
To display the number of lines, words, and bytes in the file text, enter: wc text
This results in the following output: 27 185 722 text
The numbers 27, 185, and 722 are the number of lines, words, and bytes, respectively, in the file text. To display only one or two
of the three counts include the appropriate options. For example, the following command displays only line and byte counts: wc -cl
text
27 722 text To count lines, words, and bytes in more than one file, use wc with more than one input file or with a file name pat-
tern. For example, the following command can be issued in a directory containing the files text, text1, and text2: wc -l text*
27 text 112 text1 5 text2 144 total
The numbers 27, 112, and 5 are the numbers of lines in the files text, text1, and text2, respectively, and 144 is the total number
of lines in the three files. The file name is always appended to the output. To obtain a pure number for things like reporting
purposes, pipe all input to the wc command using cat. For example, the following command will report the total count of characters
in all files in a directory. echo There are `cat *.c | wc -c` characters in *.c files
There are 1869 characters in *.c files
ENVIRONMENT VARIABLES
The following environment variables affect the execution of wc: Provides a default value for the internationalization variables that are
unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari-
ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value,
overrides the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes
of text data as characters (for example, single-byte as opposed to multibyte characters in arguments and input files) and which characters
are defined as white space characters. Determines the locale for the format and contents of diagnostic messages written to standard error
and informative messages written to standard output. Determines the location of message catalogues for the processing of LC_MESSAGES.
SEE ALSO
Commands: cksum(1), ls(1)
Standards: standards(5)
wc(1)