07-04-2012
Taking sum up all values inside the file
Hi,
Taking sum up all values inside the file by using the below command:
paste -sd+ filenmae | bc
Getting some error like "0705-001: building space exceeded on line1 stdin"
The original data looks like
SPACE SPACE SPACE 0.123 [.\] JOBNAME1
SPACE SPACE 20.325 [.\] JOBNAME2
SPACE SPACE SPACE SPACE SPACE 402.238 [.\] JOBNAME3
Like that, some thousands of records for four files. By using sed command, removing all the starting spaces in a file and storing vlaues(i.e., cpu time) column alone in a file and trying take to the count by using paste command.
I tried to use different scenarios to take the count by using awk, eventhough am getting same error.
The error is displaying for few files only. I verified the file contents there is no spaces or empty rows.
Thanks for you help in advance.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i have a script, whcih takes values from a file and assign it to one variable. this text value contains name of few object. value contains line by lie. i.e. one after another.
when i am assaign the value of this text file to a variable, it accept the value as one liner instead of one by one.... (3 Replies)
Discussion started by: jin
3 Replies
2. Shell Programming and Scripting
Dears,
Good Day !
Plz; i want to sum-up two consecutive values inside one row, and put the summation in a new column.
here the input:
1 2
4 5
6 7
the output should be:
1 2 3
4 5 9
6 7 13
If someone can help me to solve my issue !
thx anyway.
Video tutorial on how to use... (5 Replies)
Discussion started by: Ala Alzyadat
5 Replies
3. Shell Programming and Scripting
Hi All,
test file
Begin Script Run at Thu Mar 14 09:24:16 PDT 2013
tst_accounts: ws zip: WS_out_20130313.tar.gz dat: test_20130313.dat count: 63574 loaded: xx pre-merge: xx post-merge: xx timestamp: Thu Mar 14 09:30:42 PDT 2013
tst_accounts: ws zip: WS_out_20130313.tar.gz dat: s_20130313.dat... (6 Replies)
Discussion started by: bmk
6 Replies
4. Shell Programming and Scripting
I have a simple text file having payment amount value on each line. At the end of day 'n' number of payments created difference in amount that I need to match from this file.
I have information about how many payments created difference and difference amount. Please help me to build shell... (3 Replies)
Discussion started by: swats007
3 Replies
5. Shell Programming and Scripting
I have a file (let say file B) like this:
File B:
A1 3 5
A1 7 9
A2 2 5
A3 1 3
The first column defines a filename and the other two define a range in that specific file. In the same directory, I have also three more files (File A1, A2 and A3). Here is 10 sample lines... (3 Replies)
Discussion started by: Bastami
3 Replies
6. Shell Programming and Scripting
Hello,
(I'm a shell beginner)
how can I sum the bold values of the following txt-file (values.txt) with bash shell. The result of the sum should be written in a new txt file (sum.txt):
...
Thanks in advance (5 Replies)
Discussion started by: milu
5 Replies
7. Shell Programming and Scripting
I need to sum values in text file in case duplicate row are present with same name and different value below is example of data in file i have and format i need.
Data in text file
20170308
PM,U,2
PM,U,113
PM,I,123
DA,U,135
DA,I,113
DA,I,1
20170309
PM,U,2
PM,U,1
PM,I,123
PM,I,1... (3 Replies)
Discussion started by: Adfire
3 Replies
8. Shell Programming and Scripting
Hi,
I have two files with values in both.
File1:
cat 2 3
dog 4 5
elephant 6 7
camel 2 3
File2:
----+--gkf;ajf=
---+----
+----- cat -------=----+ 3 | 4 ----- dog ------++-- 5 | 9 ----++-- elephant |
5 | 7
---++ camel ------ ++++_---- || 8 | 9
I want the final file as:
cat 4... (1 Reply)
Discussion started by: npatwardhan
1 Replies
9. UNIX for Beginners Questions & Answers
I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv
abc.csv-
UTF-8,,,,,,,,,,,,,,,,,,,,,,,,,
... (6 Replies)
Discussion started by: Tahir_M
6 Replies
10. UNIX for Beginners Questions & Answers
Good day guys,
I'm having trouble in creating a logic when it comes to replacing the values inside a file.
I tried using sed command but it just doesn't work the way I want it to be.
Here is what I'm trying to achieve.
If my input file contains the values below.
NAME++GUEST1 ++GUESS2++... (3 Replies)
Discussion started by: asdfghjkl
3 Replies
LEARN ABOUT CENTOS
perl::critic::policy::valuesandexpressions::prohibitemptyquotes
Perl::Critic::Policy::ValuesAndExpressions::ProhibitEmptUsertContributed Perl DoPerl::Critic::Policy::ValuesAndExpressions::ProhibitEmptyQuotes(3)
NAME
Perl::Critic::Policy::ValuesAndExpressions::ProhibitEmptyQuotes - Write "q{}" instead of "''".
AFFILIATION
This Policy is part of the core Perl::Critic distribution.
DESCRIPTION
Don't use quotes for an empty string or any string that is pure whitespace. Instead, use "q{}" to improve legibility. Better still,
created named values like this. Use the "x" operator to repeat characters.
$message = ''; #not ok
$message = ""; #not ok
$message = " "; #not ok
$message = q{}; #better
$message = q{ } #better
$EMPTY = q{};
$message = $EMPTY; #best
$SPACE = q{ };
$message = $SPACE x 5; #best
CONFIGURATION
This Policy is not configurable except for the standard options.
SEE ALSO
Perl::Critic::Policy::ValuesAndExpressions::ProhibitNoisyStrings
AUTHOR
Jeffrey Ryan Thalhammer <jeff@imaginative-software.com>
COPYRIGHT
Copyright (c) 2005-2011 Imaginative Software Systems. All rights reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of this license
can be found in the LICENSE file included with this module.
perl v5.16.3 2014-06-09 Perl::Critic::Policy::ValuesAndExpressions::ProhibitEmptyQuotes(3)