AWK: add and sum line in output Post: 302692325

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk help required to group output and print a part of group line and original line

Hi, Need awk help to group and print lines to format the output as shown below INPUT FORMAT set echo on set heading on set spool on /* SCHEMA1 */ CREATE TABLE T1; /* SCHEMA1 */ CREATE TABLE T2; /* SCHEMA1 */ CREATE TABLE T3; /* SCHEMA1 */ CREATE TABLE T4; /* SCHEMA1 */ CREATE TABLE T5;...

2. Shell Programming and Scripting

scripting/awk help : awk sum output is not comming in regular format. Pls advise.

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. Shell Programming and Scripting

[SOLVED] Awk one line to sum up a function

I need help with debugging an error in my awk script. I have a shell script with variable named U_new_i and want to pass it to awk for use in a summation. The original file have the following content. cat test.txt -2445.7132000000 -2444.9349000000 -2444.3295000000 -2443.1814000000 ...

4. Shell Programming and Scripting

Need to have output of AWK array in one line

I have this code echo $logfile | awk ' {arr++; next} END { for (i in arr) {print i} }' that gives me this output result1 result2 result3 I try to figure out how to get it like this result1 result2 result3

5. Shell Programming and Scripting

How to sum multiple column output with awk ?

Hi Experts, I am trying to sum multiple columns and rows with awk , I want the sum of : 1] Horizontal Sum: (rows sum): 2] Vertical Sum: (Column's sum] details: # cat file1 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 40 31 32 33 34 35 36 37 38 39 70 41 42 43 44...

6. Shell Programming and Scripting

Reading ls -l output line by line awk the user name and su user to run commands

Using ksh on AIX what I am trying to do is to read the ls -l output from a file in a do while loop line by line. Extract the user name(3rd field) and the directory/file name(9th field) using awk and save them into variables. su -c to the user and change directory/file permisions to 777. Script I...

7. UNIX for Dummies Questions & Answers

awk output line by line

Hi all, New to the forum and somewhat of a Bash newbie so go easy. ;) I have some data in a tsv file, a sample of which looks like this (ignore what look like duplicates, in reality there are many more columns of data): SAMD11 NM_152486.2 intronic SAMD11 NM_152486.2 intronic...

8. Shell Programming and Scripting

Output on one line using awk or sed

I have a file of 100,000 lines in the below format: answer.bed chr1 957570 957852 NOC2L chr1 976034 976270 PERM1 chr1 976542 976787 PERM1 I need to get each on one line and so far what I have tried doesn't seem to be working. Thank you...

9. Shell Programming and Scripting

Print awk output in same line ,For loop

My code is something like below. #/bin/bash for i in `ps -ef | grep pmon | grep -v bash | grep -v grep | grep -v perl | grep -v asm | grep -v MGMT|awk '{print $1" "$8}'` do echo $i ORACLE_SID=`echo $line | awk '{print $2}'` USERNAME=`echo $line | awk '{print $1}'` done ============= But...

10. Shell Programming and Scripting

awk printing output to new line

Hi I have a file profile.txt with the below input: {"atgUserId":"736f14c4-eda2-4531-9d40-9de4d6d1fb0f","firstName":"donna","lastName":"biehler","email":"schoolathome42@live.com","receiveEmail":"y es"}, {"atgUserId":"c3716baf-9bf8-42da-8a44-a13fff68d20f","firstName":"Gilberto...

LEARN ABOUT PHP

msgfmt_format_message

MSGFMT_FORMAT_MESSAGE(3)						 1						  MSGFMT_FORMAT_MESSAGE(3)

MessageFormatter::formatMessage - Quick format message

	Object oriented style

SYNOPSIS

       publicstatic string MessageFormatter::formatMessage (string  $locale, string  $pattern, array  $args)

DESCRIPTION

	Procedural style
       string msgfmt_format_message (string  $locale, string  $pattern, array  $args)

	Quick  formatting  function  that  formats the string without having to explicitly create the formatter object. Use this function when the
       format operation is done only once and does not need and parameters or state to be kept.

PARAMETERS

	      o $locale
		- The locale to use for formatting locale-dependent parts

	      o $pattern
		- The pattern string to insert things into. The pattern uses an 'apostrophe-friendly' syntax; it is run  through  umsg_autoQuoteA-
		postrophe before being interpreted.

	      o $args
		- The array of values to insert into the format string

RETURN VALUES

	The formatted pattern string or FALSE if an error occurred

EXAMPLES

       Example #1

	      msgfmt_format_message(3) example

	      <?php
	      echo msgfmt_format_message("en_US", "{0,number,integer} monkeys on {1,number,integer} trees make {2,number} monkeys per tree
", array(4560, 123, 4560/123));
	      echo msgfmt_format_message("de", "{0,number,integer} Affen auf {1,number,integer} Baumen sind {2,number} Affen pro Baum
", array(4560, 123, 4560/123));
	      ?>

       Example #2

	      OO example

	      <?php
	      echo MessageFormatter::formatMessage("en_US", "{0,number,integer} monkeys on {1,number,integer} trees make {2,number} monkeys per tree
", array(4560, 123, 4560/123));
	      echo MessageFormatter::formatMessage("de", "{0,number,integer} Affen auf {1,number,integer} Baumen sind {2,number} Affen pro Baum
", array(4560, 123, 4560/123));
	      ?>

       The above example will output:

       4,560 monkeys on 123 trees make 37.073 monkeys per tree
       4.560 Affen auf 123 Baumen sind 37,073 Affen pro Baum

SEE ALSO

       msgfmt_create(3), msgfmt_parse(3), msgfmt_get_error_code(3), msgfmt_get_error_message(3).

PHP Documentation Group 												  MSGFMT_FORMAT_MESSAGE(3)