09-01-2016
Thanks RudiC, I love how your brain went there to "trick" CONVFMT and I never knew a carry flag. I have tried your suggestion and it works brilliantly. My input file works in tandem with your suggestion and always will. Many Many thanks.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how can we add or subtract days from the output of date command in unix...
like if i want to subtract a day from the result of date command like this..
v_date=`date +%Y%m%d`
this wud give me 20080519
now i want to subtract one day from this.. so tht it wud give me 20080518..
how do i do... (1 Reply)
Discussion started by: St.Fartatric
1 Replies
2. Shell Programming and Scripting
I have two files:
file1.txt:
FS Total Used Free Used%
/u01 10000 8000 2000 80%
/u02 10000 8000 2000 80%
/u03 10000 8000 2000 80%
/u04 10000 8000 2000 80%
/u05 10000 8000 2000 80%
/u06 10000 8000 2000 80%
/u07 10000 8000 2000 80%
/u10 10000 5000 5000 50%
file2.txt:... (7 Replies)
Discussion started by: oabdalla
7 Replies
3. Shell Programming and Scripting
Hi,
I have two files and I need to add column 3 of file1 to column 3 of file 2 > file3
I also need to repeat for column 4.
Thanks (1 Reply)
Discussion started by: dsstamps
1 Replies
4. Shell Programming and Scripting
Hi All,
I have a file of 100 lines of each having 1000 columns. I need to find the difference of each column against each other. That means, Col1-Col1; Col1-Col2; Col1-Col3;......Col1-Col1000; Col2-Col1; Col2-Col2; Col2-Col3;.... and so on ....up to Col1000-Col1000.
Lets say the file is... (6 Replies)
Discussion started by: Fredrick
6 Replies
5. Windows & DOS: Issues & Discussions
Hi,
I'm writing an batch file to create report
In the batch file iam passing two arguments:startdate and finishdate
Ex: startdate=07-sep-2009 finishdate=07-sep-2011
I need to have script that takes command line argument as input and gives me out currentdate last year and current date... (2 Replies)
Discussion started by: anand1773
2 Replies
6. Shell Programming and Scripting
ok, so i have a bunch of numbers in a file that i'd like to add up.
i dont know how to do it.
This is how far i've gotten:
echo "4 4 5 4 3 4 3 3 4 2 43 3 293 49 23" | sed 's/ / + /g' | awk -F" "
I dont want to use the expr command with this as i dont trust it. any advice?
thanks (1 Reply)
Discussion started by: SkySmart
1 Replies
7. UNIX for Dummies Questions & Answers
Hi Gurus!
I have a static date in a YYYYMMDD format; and I want get the date 2 years in the past and 2 years in the future.
static_date=20010203
old_date=$static_date - 3 years
future_date=$static_date + 2 years
I was only able to research on dates that are current and not on static... (3 Replies)
Discussion started by: kokoro
3 Replies
8. Shell Programming and Scripting
Hi everyone, I had a similar question a couple days ago but my problem has gotten significantly (to me anyway) more complex.
I have two files:
File 1:
0808 166 166 62 9 0
1000fights 1 1 2 1 0
100places2visit 2 2 2 2 0
10veronica91 167 167 3 1 0
11thgorgeous 346 346 3806 1461 122... (2 Replies)
Discussion started by: collards
2 Replies
9. Shell Programming and Scripting
Hi ,
How can I add/substruct x number of days with date?
For example
My_Date=`date`
Now I need
Hope it's clear. (2 Replies)
Discussion started by: Anupam_Halder
2 Replies
10. Shell Programming and Scripting
Hi again. Sorry for all the questions — I've tried to do all this myself but I'm just not good enough yet, and the help I've received so far from bartus11 has been absolutely invaluable. Hopefully this will be the last bit of file manipulation I need to do.
I have a file which is formatted as... (4 Replies)
Discussion started by: crunchgargoyle
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)