Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: creating a CSV file for past 7 days
Top Forums UNIX for Dummies Questions & Answers creating a CSV file for past 7 days Post 302228226 by era on Saturday 23rd of August 2008 02:00:15 PM
Old 08-23-2008
Take out the -l from the wc command and you get byte (and word) counts for each file as well. (Why did you add it in the first place?) Some simple post-processing to divide by 1,000 or 1,024 and increasing the unit is easy to add to the awk script. (Do you want MB or MiB, i.e. 1000 or 1024? See http://en.wikipedia.org/wiki/Mebibyte)

Code:
wc /data/XYZ/Daily_File*.txt |
nawk -v OFS=, '{ bytes=$3; suff="KMGT"; i=0;
   while (bytes > 1000) { bytes = int(bytes/1000); i++ }
   print $4, $1, bytes (i > 0 ? (" " substr(suff,i,1) "B") : " bytes") }'

For 1024-byte units, bytes >>= 10 is probably more efficient than bytes = int(bytes/1024)

As an engineering recommendation, I would still suggest that you put the raw numbers in the CSV file, and leave the arrangement of the presentation as KiB or whatever to the consumer of that file.
Last edited by era; 08-23-2008 at 03:12 PM.. Reason: Link to Wikipedia
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a csv file in awk

Hi All I am trying to create a csv file in the korn shell and the script segment is as follows: if then # NEED TO ADD INFO TO THE EMAIL FILE ABOUT THE DRIVE THAT'S FILLING UP echo "$drive $percent% $space "|\ awk '{printf("%d/t"|"%d/t"|"%d/t\n",... (6 Replies)
Discussion started by: Segwar
6 Replies

2. Shell Programming and Scripting

find files from the past 7 days

Hi All, I have a file which contains the listing of another directory: >cat list.dat -rwxr-xr-x 1 test staff 10240 Oct 02 06:53 test.txtdd -rwxrwxrwx 1 test staff 0 Oct 04 07:22 test.txx -rwxrwxrwx 1 test staff 132 Sep 16 2007 test_tt.sh... (6 Replies)
Discussion started by: deepakgang
6 Replies

3. UNIX for Dummies Questions & Answers

Creating a report from csv file.

Hi Gurus, I need your help in transforming the CSV file into some what a report format. My source file looks like below Date,ProdID,TimeID,LevelID 2010-08-31,200,M,1 2010-08-31,201,Q,2 2010-08-31,202,Y,1 2010-08-31,203,M,5 Output required is ... (9 Replies)
Discussion started by: naveen.kuppili
9 Replies

4. Shell Programming and Scripting

creating a csv file from this 1 liner?

I'm trying to create a csv file by running awk and sed on a number of xml files in a directory; I'm using this below: hostname; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F"/" '{ print $5 }' > /tmp/tempfile.txt; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F\" '{ print $2... (2 Replies)
Discussion started by: rich@ardz
2 Replies

5. Shell Programming and Scripting

Listing files of PAST 7 days and concatenate it...

Hi All, I want to list file of LAST 7 days acc. to its modified date and then concatinate. I have following piece of code.. For concatenate cat file1 file2 >> Output (For concatinating) find . -mtime -7 -exec basename {} \; (list past files but it is including . file also) Plz... (4 Replies)
Discussion started by: vivek1489
4 Replies

6. UNIX for Dummies Questions & Answers

Problem in creating CSV file

Hi guys, I am not experienced with Unix, so please dont mind if the question seem to be irrelevant. I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail. -I stored the query o/p in a file. -I... (6 Replies)
Discussion started by: sumitburnwal88
6 Replies

7. Shell Programming and Scripting

Subtract 2 date columns in .csv file and get output as number of days

Hi, I have one .csv file. I have 2 date columns present in file, column 2 and column 3. I need to calculate how many days exist between 2 dates. I am trying to subtract date column 2 from date column 3. Eg: my file look likes s.no, Start_date,End_Date 1, 7/29/2012,10/27/2012 2,... (9 Replies)
Discussion started by: Dimple
9 Replies

8. UNIX and Linux Applications

From past 10 days my one job is taking lots of time

One of my job is taking long running time. I need to identify from the unix log file can you please help how to troubleshoot. (1 Reply)
Discussion started by: Nsharma3006
1 Replies

9. Shell Programming and Scripting

Should pick latest file within past 3 days using UNIX script and perform steps in message below.

Hi , Can anyone help me how do perform below requirement in unix. Step1:we will receive multiple files weekly with same name(as below) in a folder(In folder we will have other files also def.dat,ghf.dat) Filenames: 1) abc_20171204_052389.dat 2)abc_20171204_052428.dat DON'T modify... (23 Replies)
Discussion started by: sunnykamal59
23 Replies

LEARN ABOUT OSX

cmp

CMP(1)								   User Commands							    CMP(1)

NAME

       cmp - compare two files byte by byte

SYNOPSIS

       cmp [OPTION]... FILE1 [FILE2 [SKIP1 [SKIP2]]]

DESCRIPTION

       Compare two files byte by byte.

       -b  --print-bytes
	      Print differing bytes.

       -i SKIP	--ignore-initial=SKIP
	      Skip the first SKIP bytes of input.

       -i SKIP1:SKIP2  --ignore-initial=SKIP1:SKIP2

	      Skip the first SKIP1 bytes of FILE1 and the first SKIP2 bytes of FILE2.

       -l  --verbose
	      Output byte numbers and values of all differing bytes.

       -n LIMIT  --bytes=LIMIT
	      Compare at most LIMIT bytes.

       -s  --quiet  --silent
	      Output nothing; yield exit status only.

       -v  --version
	      Output version info.

       --help Output this help.

       SKIP1  and  SKIP2  are  the number of bytes to skip in each file.  SKIP values may be followed by the following multiplicative suffixes: kB
       1000, K 1024, MB 1,000,000, M 1,048,576, GB 1,000,000,000, G 1,073,741,824, and so on for T, P, E, Z, Y.

       If a FILE is `-' or missing, read standard input.

AUTHOR

       Written by Torbjorn Granlund and David MacKenzie.

REPORTING BUGS

       Report bugs to <bug-gnu-utils@gnu.org>.

COPYRIGHT

       Copyright (C) 2002 Free Software Foundation, Inc.

       This program comes with NO WARRANTY, to the extent permitted by law.  You may redistribute copies of this program under the  terms  of  the
       GNU General Public License.  For more information about these matters, see the file named COPYING.

SEE ALSO

       The  full  documentation  for cmp is maintained as a Texinfo manual.  If the info and cmp programs are properly installed at your site, the
       command

	      info diff

       should give you access to the complete manual.

diffutils 2.8.1 						    April 2002								    CMP(1)
All times are GMT -4. The time now is 03:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy