Divide number of lines by the size of the same file. And create relational table. Post: 302858095

Sponsored Content

Top Forums Shell Programming and Scripting Divide number of lines by the size of the same file. And create relational table. Post 302858095 by Don Cragun on Saturday 28th of September 2013 03:02:19 PM

09-28-2013

Registered User

Why would you use ls -lh if you want to perform arithmetic operations on the file size. The -h option will produce file sizes like:

Code:

-rw-r--r--   1 dwc  staff   460B Apr 24 10:43 action
-rw-r--r--   1 dwc  staff   205K Sep 28 10:46 data.log
-rw-r--r--   1 dwc  staff    41K Apr 24 10:43 dl.awk
-rw-r--r--   1 dwc  staff   118M Apr 24 10:43 intermediate
-rwxr-xr-x   1 dwc  staff   4.9K Sep 27 13:52 lunch

while ls -l for the same set of files produces:

Code:

-rw-r--r--   1 dwc  staff        460 Apr 24 10:43 action
-rw-r--r--   1 dwc  staff     209557 Sep 28 10:46 data.log
-rw-r--r--   1 dwc  staff      42086 Apr 24 10:43 dl.awk
-rw-r--r--   1 dwc  staff  123456792 Apr 24 10:43 intermediate
-rwxr-xr-x   1 dwc  staff       5040 Sep 27 13:52 lunch

The number of lines in data.log is 4,808. The code is much more complex if you want to compute 205k/4808 than it is to compute 209557/4808.

Also note that while wisecracker is correct in noting the bash shell won't directly perform floating point calculations, recent versions of the Korn shell (ksh) will. For instance:

Code:

printf "%.2f\n" $((209557 * 1.0 / $(wc -l < data.log) ))

produces:

Code:

43.59

Code:

echo $((209557 * 1.0 / $(wc -l < data.log) ))

produces:

Code:

43.5850665557404326

This User Gave Thanks to Don Cragun For This Post:

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Create n number of files of size x

What is the best way to create 'n' number of files of size 'x' lets say n and x are given as arguments to the program.. and lets say we can simply fill the files with 0s or *'s Thanks !!

2. Shell Programming and Scripting

to create an output file as a table

Hi, I have four input files and would like to create an output file as a table. Please check the example below. File 1. 111111 222222 333333 444444 File 2. 555555 666666 777777 888888 File 3. aaaaa bbbbb ccccc ddddd

3. UNIX and Linux Applications

create table via stored procedure (passing the table name to it)

hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname' for example ...

4. Shell Programming and Scripting

Add and divide each numbers with the added number

Hi All, I am stuck with this problem. I have some 100000 (.dat) 1.dat, 2.dat,3.dat etc until 100000.dat files which look like this: 1.dat 1 2 3 4 0.99 4.54 All my files 1.dat until 100000.dat look the same but with different numbers. I have to first add all the numbers in each...

5. UNIX for Dummies Questions & Answers

create table file from different files with index

Hi, I've several files with two collumns, where first collumn can be used as index. filename1 and filename2 how to create a file I should start with cat all files and extract first collumn to create an index?

6. Shell Programming and Scripting

AWK print number of records, divide this number

I would like to print the number of records of 2 files, and divide the two numbers awk '{print NR}' file1 > output1 awk '{print NR}' file2 > output2 paste output1 output2 > output awl '{print $1/$2}' output > output_2 is there a faster way?

7. Shell Programming and Scripting

How to get the file size and count of a table using shell scripting?

Hi there, im a beginner to the shell scripting.i trying to extract a table from a db(IMD) and i have to get the count of that table and size of the file. can you help me out how to write the shall scriping for the above query.

8. Shell Programming and Scripting

Is it possible to Divide a negative number in bash script

I am using a small script to divide some numbers in a given file and display the output in another file. I am getting the following error basename: invalid option -- '5' Try `basename --help' for more information. (standard_in) 1: syntax error The script is : #!/bin/bash for i in `cat...

9. Shell Programming and Scripting

Create a control file from Table definition

Hi Team, I need to create a control file with a pre-defined structure for a given table name. The table is in teradata. Ex: Table Name: TBL1 Table structure: create multiset table tbl1, no fallback, no before journal, no after journal, checksum = default, default mergeblockratio...

10. Shell Programming and Scripting

Create a pivot table from CSV file

Gents, Can you please help me to create a pivot table from a csv file. ( I have zip the csv file) Using the file attached, columns 1,28 and 21 i would like to get something like this output JD Val 1 2 3 4 5 6 7 8 9 10 11 12 Total...

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Create n number of files of size x

Discussion started by: the_learner

2. Shell Programming and Scripting

to create an output file as a table

Discussion started by: marcelus

3. UNIX and Linux Applications

create table via stored procedure (passing the table name to it)

Discussion started by: rethink

4. Shell Programming and Scripting

Add and divide each numbers with the added number

Discussion started by: shoaibjameel123

5. UNIX for Dummies Questions & Answers

create table file from different files with index

Discussion started by: sargotrons

6. Shell Programming and Scripting

AWK print number of records, divide this number

Discussion started by: programmerc

7. Shell Programming and Scripting

How to get the file size and count of a table using shell scripting?

Discussion started by: pawanmamidi

8. Shell Programming and Scripting

Is it possible to Divide a negative number in bash script

Discussion started by: kmnr877

9. Shell Programming and Scripting

Create a control file from Table definition

Discussion started by: unankix

10. Shell Programming and Scripting

Create a pivot table from CSV file

Discussion started by: jiam912