02-21-2013
awk sum entire string
Hi I am trying to carry out a sum on a file (totals.txt).
The file looks like:
Quote:
000000027300
000000178800
So far i have this command
Quote:
awk '{ sum += $1 } END { print sum }' totals.txt
this returns 20610
I however want it to return 000000206100
Any help would be great
thanks!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hey gurus,
my-build1-abc
my-build10-abc
my-build2-abc
my-build22-abc
my-build3-abc
basically i want to numerically sort the entire lines based on the build number. I dont zero pad the numbers because thats "how it is" ;-)
sort -n won't work because it starts from the beginning.
... (10 Replies)
Discussion started by: gurpal2000
10 Replies
2. UNIX for Dummies Questions & Answers
Hello All,
I am after the script or the command which can scan the entire file for a string $PART_ID and when found to extract/copy the corresponding $PART_ID value (e.g THIRE_PTY_SOFTWARE for the 1st occurance of $PART_ID in the attached file) to a file.
Appreciate your help.
Thanks in... (3 Replies)
Discussion started by: forumthreads
3 Replies
3. Shell Programming and Scripting
Hi Experts,
I am adding a column of numbers with awk , however not getting correct output:
# awk '{sum+=$1} END {print sum}' datafile
2.15291e+06
How can I getthe output like : 2152910
Thank you..
# awk '{sum+=$1} END {print sum}' datafile
2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies
4. Web Development
Hi,
Can someone please tell me how I can replace every occurrence of a string with another string, in the entire mysql database?
What this means is, i just dont want to operate table by table. I want to search the database and automatically replace the string /opt/cacti/scripts/ with... (1 Reply)
Discussion started by: SkySmart
1 Replies
5. Shell Programming and Scripting
Hi,
I have a file whose lines are something like
Tchampionspsq^@~^@^^^A^@^@^@^A^A^Aÿð^@^@^@^@^@^@^@^@^@^@^A^@^@^@^@^?ð^@^@^@^@^@^@^@?ð^@^@^@^@^@^@pppsq^@~^@#@^@^@^@^@^@^Hw^H^@^@^@^K^@^@^@^@xp^At^@^FTtime2psq^@ ~^@^^^A^@^@^@^B^A
I need to extract all words matching T*psq from the file.
Thing is... (4 Replies)
Discussion started by: shekhar2010us
4 Replies
6. Shell Programming and Scripting
Hi All,
I have a file testarun.txt contains the below lines and i want to print the lines if the character positions 7-8 matches 01.
201401011111
201401022222
201402013333
201402024444
201403015555
201403026666
201404017777
201404028888
201405019999
201405020000
I am trying the... (4 Replies)
Discussion started by: Arunprasad
4 Replies
7. Shell Programming and Scripting
I would like to be able to use a regular expression to find and replace entire strings, but not replace if the string is a substring in a larger string.
Example:
$string = "ABC ABCDEF ABC ABCDEF ABC";
Something like - $string =~ s/ABC/XYZ/g;
->Desired:
$string = "XYZ ABCDEF XYZ ABCDEF... (3 Replies)
Discussion started by: rjulich
3 Replies
8. Shell Programming and Scripting
so im searching the process table with:
ps -ef | awk -F"./rello.java" '{ print substr($0, index($0,$2)) }'
I only want it to print everything that's infront of the "./rello.java". That's because im basically getting the arguments that was passed to the rello.java script.
this works.
... (2 Replies)
Discussion started by: SkySmart
2 Replies
9. UNIX for Beginners Questions & Answers
I want to search a small string in a large string and find the locations of the string. For this I used grep "string" -ob <file name where the large string is stored>. Now this gives me the locations of that string. Now how do I store these locations in a text file.
Please use CODE tags as... (7 Replies)
Discussion started by: ANKIT ROY
7 Replies
10. UNIX for Beginners Questions & Answers
Hi,
Sure it's an easy one, but it drives me insane.
input ("|" separated):
1|A,B,C,A
2|A,D,D
3|A,B,B
I would like to count the occurence of each capital letters in $2 across the entire file, knowing that duplicates in each record count as 1.
I am trying to get this output... (5 Replies)
Discussion started by: beca123456
5 Replies
LEARN ABOUT PHP
array_reduce
ARRAY_REDUCE(3) 1 ARRAY_REDUCE(3)
array_reduce - Iteratively reduce the array to a single value using a callback function
SYNOPSIS
mixed array_reduce NULL (array $array, callable $callback, [mixed $initial])
DESCRIPTION
array_reduce(3) applies iteratively the $callback function to the elements of the $array, so as to reduce the array to a single value.
PARAMETERS
o $array
- The input array.
o $callback
-
mixed callback (mixed $carry, mixed $item)
o $carry
- Holds the return value of the previous iteration; in the case of the first iteration it instead holds the value of $ini-
tial.
o $item
- Holds the value of the current iteration.
o $initial
- If the optional $initial is available, it will be used at the beginning of the process, or as a final result in case the array
is empty.
RETURN VALUES
Returns the resulting value.
If the array is empty and $initial is not passed, array_reduce(3) returns NULL.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.3.0 | |
| | |
| | Changed $initial to allow mixed, previously |
| | integer. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
array_reduce(3) example
<?php
function sum($carry, $item)
{
$carry += $item;
return $carry;
}
function multiplication($carry, $item)
{
$carry *= $item;
return $carry;
}
$a = array(1, 2, 3, 4, 5);
$x = array();
var_dump(array_reduce($a, "sum")); // int(15)
var_dump(array_reduce($a, "multiplication", 10)); // int(1200), because: 10*1*2*3*4*5
var_dump(array_reduce($x, "sum", "No data to reduce")); // string(17) "No data to reduce"
?>
SEE ALSO
array_filter(3), array_map(3), array_unique(3), array_count_values(3).
PHP Documentation Group ARRAY_REDUCE(3)