How to add subtotal and total according 3rd field mentioned below table? Post: 302957836

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get the total of a field in all the lines of a group

Hi I have a Fixed format data file where I need to to get the total of the field at certain position in a file for a group of lines. In this data file I need the total of all the field ats position 30:39 for each line starting with 6 and for each group startign with 5. Which means for...

2. Shell Programming and Scripting

Deleting every 3rd field using awk

I have a file whose format is like the following 350,2,16.2,195,2,8.0 every 3rd column of this file should be deleted. How can i achieve this tried with the following iostat -D -l 2 | /usr/xpg4/bin/awk ' NR>2 { for (i=0;i<=NF;i++)if(i%3==0)$i=""};' but no luck

3. Shell Programming and Scripting

Total records in table

Hi, I am having two tables. A & B I want to know the total number of records in each table and need to store each value in some variables to process further in the code. How it can be done ? With Regards

4. Shell Programming and Scripting

Adding total of first field for each number in the second field

Dears, I need a script or command which can find the unique number from the second filed and against that number it adds the total of first field . 17215630 , 0 907043 ,1 201050 ,10 394149 ,4 1964 ,9 17215630, 0 907043 ,1 201050, 10 394149 ,4 1964 ,9 1234234, 55 23 ,100 33 ,67 ...

5. Shell Programming and Scripting

only print line if 3rd field is 01

Similar question... I have a space delimited text file and I want to only print the lines where the 3rd word/field/column is equal to "01" awk '{if $3 = "01" print $0}' something like this. I meant to say: only print line IF 3rd field is 01

6. Shell Programming and Scripting

Check a field in a table

I have made a table PRD_WORK_LM.test and it contains one field, ctrl_test. This field contains a 0 or a 1. I want to write a unix script that goes like this: IF ctrl_test = 1 THEN ... ELSE exit FI How can I write this in a script? Do I have to do this within bteq? or outside bteq? can...

7. Solaris

3rd field in /etc/shadow

Searched and searched, but could not find a official answer. In Solaris, on a new server build, all the system accounts look like this: # cat /etc/shadow root:#########:6445:::::: daemon:NP:6445:::::: bin:NP:6445:::::: sys:NP:6445:::::: adm:NP:6445:::::: lp:NP:6445::::::...

8. Shell Programming and Scripting

Need the output in the mentioned Table format

Hi Friends, I have the script output like below: Script Output: ----------------------------------------------------------------------- Details of the Client: ----------------------- name: server1; save set: All; ...

9. Shell Programming and Scripting

Calculate the total 4 field based on the conditions

Please help me to write a script Match with ACNO & NAME if it matched calculate the total val1 val2 val3 and val4 and GT is total of ACNO wise.please check the output Table ----------------- 1005|ANDP|ACN|20|50|10|30 1005|ANDP|ACN|20|10|30|40 1001|AND|NAC|40|50|40|50...

10. Shell Programming and Scripting

awk to calculate total and percent off field in file

Trying to use awk to print the lines in file that have either REF or SNV in $3, add a header line, sort by $4 in numerical order. The below code does that already, but where I am stuck is on the last part where the total lines are counted and printed under Total_Targets, under Targets_less_than is...

LEARN ABOUT DEBIAN

simplify

SIMPLIFY(1)						      General Commands Manual						       SIMPLIFY(1)

NAME

       simplify - a script to simplify a MIME message

SYNOPSIS

       simplify [args ...] < message > othermessage

DESCRIPTION

       This manual page documents briefly the simplify command.  simplify is a Perl script to simplify a MIME message.

       This script never loads the entire message into memory, but does dump it's entire contents to disk once.

OPTIONS

       mime=no
	      Don't use MIME, no HTML mail allowed.

       testing=yes
	      Run in testing mode (suppress randonmess)

       saveall=yes
	      Save all attachments to files.

       temp=/path/to/working/dir/
	      Defaults to /tmp.

       url=http://box/path/
	      URL-prefix for printing paths to attachments

       header=text...
	      Text preceding the attachment URL list.

       textsig=/path/to/file
	      Text signature to append to text parts.

       htmlsig=/path/to/file
	      HTML signature to append to HTML parts.

       If  "saveall"  is yes, then the script will save all attachments to disk so people can access their contents later.  If an URL is specified
       then that automatically implies "saveall=yes".  Without this, the default behavior is to only save text and html parts, and delete them and
       all working directories when the script is finished.

SEE ALSO

       sanitizer(1).  More info on configuration: /usr/share/doc/sanitizer/sanitizer.html

AUTHOR

       Bjarni R. Einarsson <bre@klaki.net>

       This manual page was written by Alberto Gonzalez Iniesta <agi@agi.as> for the Debian GNU/Linux system (but may be used by others).

								   May 14, 2003 						       SIMPLIFY(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get the total of a field in all the lines of a group

Discussion started by: appsguy616

2. Shell Programming and Scripting

Deleting every 3rd field using awk

Discussion started by: achak01

3. Shell Programming and Scripting

Total records in table

Discussion started by: milink

4. Shell Programming and Scripting

Adding total of first field for each number in the second field

Discussion started by: shary