Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Add column that shows how old a file is
Top Forums Shell Programming and Scripting Add column that shows how old a file is Post 302376848 by cdunavent on Wednesday 2nd of December 2009 12:34:49 PM
Old 12-02-2009
The code does work...

Code:
for FILENAME in /home/voicem/ivr/arivra/*.tar
do
let AGE=(`date +%s` - `date -r $FILENAME +%s`)/86400
echo $AGE
done

The results are exactly what I expected...it is a list of the age of each file (in days)...

Code:
$ ./test
28
21
14

However, I still need help with getting the age (in days) to show up to the right of each file. I'd like to see this:
Code:
$ ls -l
total 9830796
-rw-r--r-- 1 voicem voicem 2011396608 Oct 21 03:06 file1.tar 28 
-rw-r--r-- 1 voicem voicem 2010897920 Oct 28 02:32 file2.tar 21
-rw-r--r-- 1 voicem voicem 2007906816 Nov 4 02:29 file3.tar 14

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to add a particular column alone in a file

Hi I have file which contains 5 coulmns i need to add the fifth column value and put it in the desired location in the same column. Here is the sample file.. ashop0004 SQL- 06/14/2009 06/14/2009 00:04:28 SUM ashop0004 SQL- 06/14/2009 06/14/2009 00:00:37 ... (22 Replies)
Discussion started by: cutechaps
22 Replies

2. Shell Programming and Scripting

Need to add letters to a column and add in a new column subtracting from another column

So I have this input 1 10327 rs112750067 T C . PASS DP=65;AF=0.208;CB=BC,NCBI 1 10469 rs117577454 C G . PASS DP=2055;AF=0.020;CB=UM,BC,NCBI 1 10492 rs55998931 C T . PASS DP=231;AF=0.167;CB=BC,NCBI 1 10583 rs58108140 G A ... (3 Replies)
Discussion started by: kellywilliams
3 Replies

3. Shell Programming and Scripting

Add column to a file

Hola, How can I add a column to a existing file?? PS: The column which should be added need to be the first column and it will be a parameter from the script. Example: 1 name1 2 name2 3 name3 4 name3 Need to add parameter $file as a first column. $file is a file name with time... (6 Replies)
Discussion started by: Olivia
6 Replies

4. Shell Programming and Scripting

How to add a column from other file?

Dear all, Lets say, I've a file a.txt containing two columns, like a1 b1 .. .. .. .. and another file b.txt containg two columns, like a1 c1 .. .. .. .. I need to put c1 column from b.txt file to the a.txt file. So, the output should be a1 b1 c1 .. .. .. .. ... (4 Replies)
Discussion started by: mkg
4 Replies

5. Shell Programming and Scripting

How to add day of week at the end of each line that shows the date?

I have a file that looks like: file1: www_blank_com 20121008153552 www_blank_com 20121008162542 www_blank_com 20121009040540 www_blank_com 20121009041542 www_blank_com 20121010113548 www_blank_com 20121011113551 www_blank_com 20121012113542 I want the new file to show the day of... (3 Replies)
Discussion started by: castrojc
3 Replies

6. Shell Programming and Scripting

Help with add existing file name as new data column in new output file

Input File 1 cat S1.txt MI0043 2731 miR-1 Input File 2 cat S4.txt MI006 310 CiR-1 MI057 10 CiR-24 MI750 5 CiR-24 Desired Output File 1 cat S1.txt.out MI0043 2731 miR-1 S1.txt Desired Output File 2 cat S4.txt.out MI006 310 CiR-1 S4.txt (3 Replies)
Discussion started by: perl_beginner
3 Replies

7. Shell Programming and Scripting

Add a new column to file

I have file like this b,c 10,20 30,40 50,60 Now I want to add a new column a with fixed values for all the rows a,b,c 60,10,20 60,30,40 60,50,60 Please let me know how can we do this in unix. (4 Replies)
Discussion started by: weknowd
4 Replies

8. UNIX for Dummies Questions & Answers

Add a column to a file

Hi, I have this data file that contains: 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H 9 I I want the results to be: 1 A A 2 B A 3 C A 4 D A 5 E A 6 F A 7 G A 8 H A (8 Replies)
Discussion started by: bobo
8 Replies

9. Shell Programming and Scripting

Add new column in the file

Hi Team I have file as below empno,ename,sal 123,smith,1000 124,adams,2000 Required output: Using AWK empno,ename,sal,deptno 123,smith,1000 124,adams,2000 Thanks, Murali (5 Replies)
Discussion started by: bmk
5 Replies

10. UNIX for Beginners Questions & Answers

Add new column from another file

Hi, I have 2 files. file1 contains by lines: hash:salt:id file2 contains by lines: username:hash:salt I would like to add a new coloumn (id) form file1 to file2. The new file should contains: username:hash:salt:id Note: file1 contains less rows than file2. I tried paste -d':' file1... (12 Replies)
Discussion started by: freeroute
12 Replies

LEARN ABOUT PHP

db2_columns

DB2_COLUMNS(3)								 1							    DB2_COLUMNS(3)

db2_columns - Returns a result set listing the columns and associated metadata for a table

SYNOPSIS

       resource db2_columns (resource  $connection, [string  $qualifier], [string  $schema], [string  $table-name], [string  $column-name])

DESCRIPTION

	Returns a result set listing the columns and associated metadata for a table.

PARAMETERS

	      o $connection
		- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.

	      o $qualifier
		- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.

	      o $schema
		- The schema which contains the tables. To match all schemas, pass '%'.

	      o $table-name
		- The name of the table or view. To match all tables in the database, pass NULL or an empty string.

	      o $column-name
		- The name of the column. To match all columns in the table, pass NULL or an empty string.

RETURN VALUES

	Returns a statement resource with a result set containing rows describing the columns matching the specified parameters. The rows are com-
       posed of the following columns:

       +------------------+---------------------------------------------------+
       |   Column name	  |						      |
       |		  |						      |
       |		  |		       Description		      |
       |		  |						      |
       +------------------+---------------------------------------------------+
       |    TABLE_CAT	  |						      |
       |		  |						      |
       |		  | Name of the catalog. The value is  NULL  if  this |
       |		  | table does not have catalogs.		      |
       |		  |						      |
       |   TABLE_SCHEM	  |						      |
       |		  |						      |
       |		  |		   Name of the schema.		      |
       |		  |						      |
       |   TABLE_NAME	  |						      |
       |		  |						      |
       |		  |	       Name of the table or view.	      |
       |		  |						      |
       |   COLUMN_NAME	  |						      |
       |		  |						      |
       |		  |		   Name of the column.		      |
       |		  |						      |
       |    DATA_TYPE	  |						      |
       |		  |						      |
       |		  | The  SQL  data type for the column represented as |
       |		  | an integer value.				      |
       |		  |						      |
       |    TYPE_NAME	  |						      |
       |		  |						      |
       |		  | A string representing the data type for the  col- |
       |		  | umn.					      |
       |		  |						      |
       |   COLUMN_SIZE	  |						      |
       |		  |						      |
       |		  | An	integer  value	representing  the size of the |
       |		  | column.					      |
       |		  |						      |
       |  BUFFER_LENGTH   |						      |
       |		  |						      |
       |		  |  Maximum number of bytes necessary to store  data |
       |		  | from this column.				      |
       |		  |						      |
       | DECIMAL_DIGITS   |						      |
       |		  |						      |
       |		  |  The  scale of the column, or NULL where scale is |
       |		  | not applicable.				      |
       |		  |						      |
       | NUM_PREC_RADIX   |						      |
       |		  |						      |
       |		  |  An integer value of either 10  (representing  an |
       |		  | exact  numeric  data  type),  2  (representing an |
       |		  | approximate numeric data type), or	NULL  (repre- |
       |		  | senting a data type for which radix is not appli- |
       |		  | cable).					      |
       |		  |						      |
       |    NULLABLE	  |						      |
       |		  |						      |
       |		  | An integer value representing whether the  column |
       |		  | is nullable or not. 			      |
       |		  |						      |
       |     REMARKS	  |						      |
       |		  |						      |
       |		  |	       Description of the column.	      |
       |		  |						      |
       |   COLUMN_DEF	  |						      |
       |		  |						      |
       |		  |	      Default value for the column.	      |
       |		  |						      |
       |  SQL_DATA_TYPE   |						      |
       |		  |						      |
       |		  | An	integer  value	representing  the size of the |
       |		  | column.					      |
       |		  |						      |
       |SQL_DATETIME_SUB  |						      |
       |		  |						      |
       |		  |  Returns an integer value representing a datetime |
       |		  | subtype code, or NULL for SQL data types to which |
       |		  | this does not apply.			      |
       |		  |						      |
       |CHAR_OCTET_LENGTH |						      |
       |		  |						      |
       |		  |  Maximum length in octets for  a  character  data |
       |		  | type  column,  which matches COLUMN_SIZE for sin- |
       |		  | gle-byte character set data,  or  NULL  for  non- |
       |		  | character data types.			      |
       |		  |						      |
       |ORDINAL_POSITION  |						      |
       |		  |						      |
       |		  | The  1-indexed  position of the column in the ta- |
       |		  | ble.					      |
       |		  |						      |
       |   IS_NULLABLE	  |						      |
       |		  |						      |
       |		  |  A string value where 'YES' means that the column |
       |		  | is nullable and 'NO' means that the column is not |
       |		  | nullable.					      |
       |		  |						      |
       +------------------+---------------------------------------------------+
SEE ALSO

       db2_column_privileges(3), db2_foreign_keys(3), db2_primary_keys(3),  db2_procedure_columns(3),  db2_procedures(3),  db2_special_columns(3),
       db2_statistics(3), db2_table_privileges(3), db2_tables(3).

PHP Documentation Group 													    DB2_COLUMNS(3)
All times are GMT -4. The time now is 02:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy