Your sort is missing the key to sort by (unless you want to sort from the start of line), and your awk just prints an empty line when field 1 (not if "name", i.e. field 3) changes and doesn't do any totals. BTW, how do we know "ASH" and "SHA" belong together, i.e. are to be grouped, as well as "FL" and "KL"?
As an interim step, try
Hi Rudic,
can you please help me how can i assign TMP (TMP=$1|$3 or $1|$2) veriable instead of $3 want to pass two values condition $1 and $2 or $1 and $3 if it is matching then dispaly subtotal and Grand total should be account wise mean $1 wise also diplay the record account order wise like 111to115
Appriciate your replay
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... (27 Replies)
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 Replies)
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 (2 Replies)
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
... (2 Replies)
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 (2 Replies)
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... (5 Replies)
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::::::... (6 Replies)
Hi Friends,
I have the script output like below:
Script Output:
-----------------------------------------------------------------------
Details of the Client:
-----------------------
name: server1;
save set: All;
... (3 Replies)
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... (22 Replies)
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... (4 Replies)
Discussion started by: cmccabe
4 Replies
LEARN ABOUT LINUX
shtool-mdate
SHTOOL-MDATE.TMP(1) GNU Portable Shell Tool SHTOOL-MDATE.TMP(1)NAME
shtool-mdate - GNU shtool pretty-print last modification time
SYNOPSIS
shtool mdate [-n|--newline] [-z|--zero] [-s|--shorten] [-d|--digits] [-f|--field-sep str] [-o|--order spec] path
DESCRIPTION
This command pretty-prints the last modification time of a given file or directory path, while still allowing one to specify the format of
the date to display.
OPTIONS
The following command line options are available.
-n, --newline
By default, output is written to stdout followed by a "newline" (ASCII character 0x0a). If option -n is used, this newline character is
omitted.
-z, --zero
Pads numeric day and numeric month with a leading zero. Default is to have variable width.
-s, --shorten
Shortens the name of the month to a english three character abbreviation. Default is full english name. This option is silently ignored
when combined with -d.
-d, --digits
Use digits for month. Default is to use a english name.
-f, --field-sep str
Field separator string between the day month year tripple. Default is a single space character.
-o, --order spec
Specifies order of the day month year elements within the tripple. Each element represented as a single character out of ``"d"'',
``"m"'' and ``"y"''. The default for spec is ``"dmy"''.
EXAMPLE
# shell script
shtool mdate -n /
shtool mdate -f '/' -z -d -o ymd foo.txt
shtool mdate -f '-' -s foo.txt
HISTORY
The GNU shtool mdate command was originally written by Ulrich Drepper in 1995 and revised by Ralf S. Engelschall <rse@engelschall.com> in
1998 for inclusion into GNU shtool.
SEE ALSO shtool(1), date(1), ls(1).
18-Jul-2008 shtool 2.0.8 SHTOOL-MDATE.TMP(1)