Sponsored Content
Top Forums Shell Programming and Scripting stripping out non-numeric values in a list Post 302296986 by badoshi on Thursday 12th of March 2009 09:00:11 AM
Old 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

[bash]Stripping lines from a list

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

Remove non numeric values from a variable

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

numeric values ending in 'U'

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

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

Only print lines with 3 numeric values

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

Assigning numeric values to variable

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

How to find the X highest values in a list depending on the values of another list with bash/awk?

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

Sort by second column numeric values

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
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)
All times are GMT -4. The time now is 02:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy