retrieve timestamp associated with a file


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers retrieve timestamp associated with a file
# 1  
Old 08-08-2002
Question retrieve timestamp associated with a file

Hi All,
I am involved in a Datawarehousing project where my data files(ASCII text) are loaded on a Unix directory. When I do a Ls -l in Unix prompt i get a file listing along with the timestamp when these files were created/put on the server. I need to retrieve the timestamp associated with each file. Is there any command that takes in the filename as an argument and returns the timestamp associated with it?? Or is there any other way to get the timestamp for each file..
Urgent help is sought!!
Thanks in advance..
Nilotpal.
# 2  
Old 08-08-2002
"ls -l" is pretty much it. I assume that you know that "ls -l" can indeed take arguments? So:
ls -l filename
would seem to do what you want. If this is not the case, please tell us why.
# 3  
Old 08-08-2002
If you wanted to create a separate file that just had the filename in one column and the 'timestamp' in another...then you'd just use the ls -l command and cut the columns that you want (filename and date time....)

for example if all you files were data_xxx (where xxx differs but they all start with data_)

ls -l data_* | cut -c42-100 > my_file

Ideally with cut you'd use the -f for fields with the -d for delimiter, however the delimiter is space and the different columns have a different number of spaces as a delimiter. So you can just cut the characters 42-100 (note the 42 may differ so you need to find where the first character you want is..and 100 just goes way past the end to ensure you get all long filenames.)

There may be a way to use the -d and -f if you can specify the treat consecutive delimiters as one, however then you'd have to watch for filenames with spaces in them anyway.

Anyone know if there is a way with cut to treat consecutive delimiters as one?
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Grep: Retrieve two strings from one file to find them anyone on line in another file

I am having trouble matching *two* strings from one file anywhere in a line of a second file, and could use some help getting this figured out. My preference would be to use grep for this because I would like to take advantage of its -A option. The latter is due to the fact that I would like both... (2 Replies)
Discussion started by: jvoot
2 Replies

2. UNIX for Dummies Questions & Answers

Hot to retrieve *.sql file names which we refer in .sh file.

Hi Guys, How to retrieve/get *.sql file names which we refer in all *.sh files. Can any one help me on this. Thanks, Kolipaka (3 Replies)
Discussion started by: lakshmanrk811
3 Replies

3. UNIX for Dummies Questions & Answers

How to compare a file by its timestamp and store in a different location whenever timestamp changes?

Hi All, I am new to unix programming. I am trying for a requirement and the requirement goes like this..... I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve... (2 Replies)
Discussion started by: mailsara
2 Replies

4. Shell Programming and Scripting

Getting a relative timestamp from timestamp stored in a file

Hi, I've a file in the following format 1999-APR-8 17:31:06 1500 3 45 1999-APR-8 17:31:15 1500 3 45 1999-APR-8 17:31:25 1500 3 45 1999-APR-8 17:31:30 1500 3 45 1999-APR-8 17:31:55 1500 3 45 1999-APR-8 17:32:06 1500 3 ... (1 Reply)
Discussion started by: vaibhavkorde
1 Replies

5. Shell Programming and Scripting

How to retrieve the current timestamp?

I am doing this in my script .. currenttimestamp=`db2 "select current timestamp from SYSIBM.SYSDUMMY1 with ur"` echo s $currenttimestamp but this is how its shows s 1 -------------------------- 2011-04-18-12.43.25.345071 1 record(s) selected. How can I just get the timestamp... (6 Replies)
Discussion started by: mitr
6 Replies

6. Shell Programming and Scripting

retrieve string from file

hi, I have write a code to retrive data from each line of a file: sed -e '/^#/d' file.csv | awk '{ printf "TEST,%s:AUX,%s;\n", $0, "'A'"}' > pippo.txt where the input file.csv was like this: 1234 2345 2334 3344 and the output of my code is a file with: TEST,1234:AUX,A;... (7 Replies)
Discussion started by: fafo77
7 Replies

7. UNIX for Advanced & Expert Users

retrieve the file.

How will retrieve for a particular months file in UNIX say for example from January to February 2008. (1 Reply)
Discussion started by: rajesh08
1 Replies

8. Shell Programming and Scripting

how to retrieve base name of the file

I have a file name stored in a variable. A=/bb/data/f233pdb How can I retrive the base name (f233pdb) and the path (/bb/data/) and assign them to two new variables, so the result will look like this B=f233pdb C=/bb/data/ Thansk a lot for any help -A (8 Replies)
Discussion started by: aoussenko
8 Replies

9. Shell Programming and Scripting

retrieve value from a file

hi i have a cfg file,it contains lpdma520.dev.ipc.us.aexp.com=SUBMCORE.REQUEST.FT lpdma521.dev.ipc.us.aexp.com=SUBMCORE.REQUEST.FTREQ lpdma522.dev.ipc.us.aexp.com=SUBMITSECUREFILEFLOW i am retrieving the values using the function RetrieveCfgvalue() { CFG_VALUE=`grep "$2="... (1 Reply)
Discussion started by: satish@123
1 Replies

10. Shell Programming and Scripting

Retrieve data from a file

Hello guys I want to retrieve two data from a file, like this: bash-2.03$ cat numtest 123456 123457 bash-2.03$ more ./test_num #!/bin/bash num1= num2= cnt=1 while read x do num${cnt}=$x cnt=$(($cnt+1)) done <$1 echo $num1 "\n" $num2 But when i executed this script, error... (2 Replies)
Discussion started by: tpltp
2 Replies
Login or Register to Ask a Question