03-12-2009
stripping out non-numeric values in a list
hi all,
i'm very new to scripting and have the folllowing issue. I have used a few commands to get a list of numbers, but I need to strip away the non-numeric ones, and then need a total of all values. any ideas?
root@unixserver # cat myfile | awk '{print $8}'| sort -rn
1504
1344
896
704
608
448
416
416
000:05:14
000:05:14
The output changes day by day, so trimming the last 2 entries is not really suitable. What I need is the ability to take out whole entries that are not numbers - then the sum of remaining entries.
Many thanks.
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello!
I have a script that is (among other things) doing the following:
list=/tmp/list1.txt
ncftpls -u <user> -p <password> -x "-l1" server.domain.tld > $list
cat $list | nl
echo "Choose file: "
read file
cat /tmp/list1.txt | nl | grep $file | sed -e "s/$file//g" -e "s/ //g" | column -t... (8 Replies)
Discussion started by: noratx
8 Replies
2. Shell Programming and Scripting
Hello all,
I am working on a basic script but need a little help.
Issue:
I am running a SQL Query using sqlplus and a shell script. I have the output of the statement stored as variable $A. $A is set to "other text here 45678754 other text here". I need to strip all text except that numeric... (13 Replies)
Discussion started by: ownedthawte
13 Replies
3. Programming
I am getting back on the C++ programming after many years away. I recently received an SDK that has code like this where numeric values end in 'U'. What does this mean?
if ((ptr % 16U) == 0U)
return buffer; (3 Replies)
Discussion started by: sneakyimp
3 Replies
4. Shell Programming and Scripting
How to check if the file contains only numeric values.
I don't want to read entire file it eats lot of cpu
Or any way which consumes less memory n cpu..
Please suggest
-S (2 Replies)
Discussion started by: sunilmenhdiratt
2 Replies
5. UNIX for Dummies Questions & Answers
Hey guys & gals,
I am hoping for some advice on a sed or awk command that will
allow to only print lines from a file that contain 3 numeric values.
From previous searches here I saw that ygemici used the sed command
to remove lines containing more than 3 numeric values ;
however how... (3 Replies)
Discussion started by: TAPE
3 Replies
6. Shell Programming and Scripting
I have a code like this
v_num=9
comp_num=39
if
then
echo "pass"
fi
echo "end"
I am getting an error
ksh: v_num=99
comp_num=39
if
then
echo "pass"
fi
echo "end" (3 Replies)
Discussion started by: swayam123
3 Replies
7. Shell Programming and Scripting
Hi everyone,
This is an exemple of inpout.txt file (a "," delimited text file which can be open as csv file):
ID, Code, Value, Store SP|01, AABBCDE, 15, 3 SP|01, AABBCDE, 14, 2 SP|01, AABBCDF, 13, 2 SP|01, AABBCDE, 16, 3 SP|02, AABBCED, 15, 2 SP|01, AABBCDF, 12, 3 SP|01, AABBCDD,... (1 Reply)
Discussion started by: jeremy589
1 Replies
8. UNIX for Advanced & Expert Users
From googling and reading man pages I figured out this sorts the first column by numeric values.
sort -g -k 1,1
Why does the -n option not work? The man pages were a bit confusing.
And what if I want to sort the second column numerically? I haven't been able to figure that out. The file... (7 Replies)
Discussion started by: cokedude
7 Replies
LEARN ABOUT DEBIAN
nnstats
NNSTATS(1m) NNSTATS(1m)
NAME
nnstats - display nnmaster collection and expire statistics
SYNOPSIS
nnstats [ -lt ] [ -d month day ] [ -m month ] [ logfile ]...
DESCRIPTION
nnstats will extract the collection (C) and expiration (X) entries from the log file and calculate total and average number of articles,
groups and elapsed time per day, per month, or for the duration of the whole log file.
Normally only a summary for the specified period is printed. If -l is specified, the statistics for each day in the period is also
printed, and if -t is specified the summary is not printed.
Normally the statistics is collected for all days in the log files (or the current log file if one is not specified).
If "-m month" is specified, the statistics for that month is calculated. The month is specified in normal date notation, i.e. a capital-
ized three letter abbreviation like Jan, Feb, ...
If "-d month day" is specified, the statistics for that date only is calculated and printed.
FILES
../Log The log file
SEE ALSO
nn(1), nnusage(1M), nnadmin(1M), nnmaster(8)
NOTES
If nnmaster is run with options -LCX, nnstats will not work, because the necessary entries are not written to the log file.
AUTHORS
Mark Moraes <moraes@csri.toronto.edu>
Kim F. Storm <storm@texas.dk>
4th Berkeley Distribution Release 6.6 NNSTATS(1m)