I get a transaction file and I need to sum two of the columns. I each record I get a debit(D) or credit(C) indicator. Then I get an amount field. I need to sum the total dollar value of debits and credits.
I know I can loop through each record and get the sum total but is there a better way with... (7 Replies)
Hi
I need to sum of sub total amounts. Please any ideas
file1.txt
type: xx
xyz 200 300
xyz1 300 400
Sub total 500 700
type:yy
abc 200 300
abc1 100 100
Sub total ... (4 Replies)
Hi, all:
I've got two folders, say, "folder1" and "folder2".
Under each, there are thousands of files.
It's quite obvious that there are some files missing in each. I just would like to find them. I believe this can be done by "diff" command.
However, if I change the above question a... (1 Reply)
Suppose I have a XSD definition of amount:
<xs:element name="Amount" type="amount>
And the amounts themselves are given in the following format in the XML:
<amount>1.000.00</amount>
In other words, the thousand separator and the decimal point are the same.
Does this require that the parser... (3 Replies)
Good day All,
I have requirement where my input data looks like below
] Message5
Expecting Output as
04/MAR/2104 ||| 23:15:45 ||| servername ||| NOTIFICATION |||message1||||||userId|||||| Message5
I could not use space delimiter as in the messages I would be having them as... (2 Replies)
Hi, I am new to UNIX and need your help in formatting the below input command to the desire output
Input:
CREATE UNIQUE INDEX XPKTABLE1
(
COL1,
COL2
) ON TABLE_NM;
Output:
COMMENT ON TABLE DB_NM.TABLE_NM AS 'PK=,COL1,COL2; ';
In... (14 Replies)
All, I've searched and haven't found a solution for my particular issue.
I have a file with lines of data that contain varying amounts of underscores imbedded. But all the strings have a final underscore and an interface name:
dmk_hcn_dalian2.XXXX.XXX.XX.COM_Se0/0/0... (4 Replies)
Discussion started by: turk22
4 Replies
LEARN ABOUT CENTOS
column
COLUMN(1) User Commands COLUMN(1)NAME
column - columnate lists
SYNOPSIS
column [options] file...
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file or, by default, from
standard input. Empty lines are ignored.
OPTIONS -c, --columns width
Output is formatted to a width specified as number of characters.
-t, --table
Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the separator. Table output is useful for pretty-printing.
-s, --separator separators
Specify possible table delimiters (default is whitespace).
-o, --output-separator separators
Specify table output delimiter (default is two whitespaces).
-x, --fillrows
Fill columns before filling rows.
-h, --help
Print help and exit.
ENVIRONMENT
The environment variable COLUMNS is used to determine the size of the screen if no other information is available.
EXAMPLES
sed 's/#.*//' /etc/fstab | column -t
BUGS
The util-linux version 2.23 changed -s option to be non-greedy, for example:
$ printf "a:b:c
1::3
" | column -t -s ':'
old output:
a b c
1 3
new output (since util-linux 2.23)
a b c
1 3
SEE ALSO colrm(1), ls(1), paste(1), sort(1)HISTORY
The column command appeared in 4.3BSD-Reno.
AVAILABILITY
The column command is part of the util-linux package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux/.
util-linux October 2010 COLUMN(1)