Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Replacing Date in the file with Create date and timestamp

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Replacing Date in the file with Create date and timestamp
# 8  
Old 09-17-2015
here's the solution with the stat:
Code:
BEGIN {
  FS="(-import[.]*)|([.])"
  OFS="|"
}
function fileC(fileName,   cmd,line, lineA)
{
   cmd="stat -c %w " fileName
   cmd | getline line; close(cmd)
   split(line, lineA, " ")
   gsub("-", "",lineA[1])
   return(lineA[1])
}
{
  print substr($1,index($1,"-")+1),(NF==2)?fileC($0):sqrt($(NF-1)^2)
}

I don't have Solaris at my disposal. What's the output of 'ls -Eu'?
Usually 'file creation time' is not readily available....

---------- Post updated at 04:10 PM ---------- Previous update was at 03:49 PM ----------

here's an alternative with perl:
ls -1 imap* | nawk -f saan.awk where saan.awk is:
Code:
BEGIN {
  FS="(-import[.]*)|([.])"
  OFS="|"
}
function fileC(fileName,   cmd,line, lineA)
{
   #cmd="stat -c %w " fileName
   cmd="perl -e '@d=localtime ((stat(shift))[10]); printf \"%4d%02d%02d\n\", $d[5]+1900,$d[4]+1,$d[3]' " fileName
   cmd | getline line; close(cmd)
   split(line, lineA, " ")
   gsub("-", "",lineA[1])
   return(lineA[1])
}
{
  print substr($1,index($1,"-")+1),(NF==2)?fileC($0):sqrt($(NF-1)^2)
}

Last edited by vgersh99; 09-17-2015 at 05:16 PM..
# 9  
Old 09-17-2015
Sorry, my fault - la is an alias for ls -l (lower case L). So - try
Code:
ls -l imap* | awk '...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

File Timestamp and date comparsion

Hi, I have many files in the source directory but I need to process with the latest timestamp file. I am using linux operating system. i want extract the file created timestamp( Ext_File_create_date=) With this format YYYYMMDD- i have searched the relevent command in the unix forms but did... (5 Replies)
Discussion started by: onesuri
5 Replies

2. Shell Programming and Scripting

Check if a date field has date or timestamp or date&timestamp

Hi, In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date&timestamp. I have to figure out the the data is a date or time stamp or date&timestamp. If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
1 Replies

3. Shell Programming and Scripting

To get max/min Date/Timestamp from a file

I want to get maximum/minimum date/timestamp from a data file ? Sample Input File ============= rec#,order_dt,ext_ts 1,2010-12-01,2010-12-01 17:55:23.222222 2,2011-11-05,2010-12-01 19:55:23.222222 3,2009-10-01,2010-12-01 18:55:23.222222 for above file Maximum Order_dt = 2011-11-05... (5 Replies)
Discussion started by: vikanna
5 Replies

4. Shell Programming and Scripting

replacing date with a variable in a file

Hi, I've a variable for example.. ACTIVATION_DATE=2010-11-11 (the date above is a result of a sql query and not hardcoded) now there is another file (test_2.parm) where there are many variables predefined.. REG_CODE=111 ACT_DATE=2010-10-10 CAN_DATE=8888-31-12 Now I want to search for... (1 Reply)
Discussion started by: RRVARMA
1 Replies

5. Shell Programming and Scripting

searching a date and replacing with another date

I have a text file that i want to search through and pick out any dates that are formatted like MM/DD/YYYY and replace them with a date i want like 10/29/2009. any idea show i would do this?:) Snapshot of my text file: test4>s44syd5172>070>528>ENU>nongnuan>wanrawee>sr2330532>... (7 Replies)
Discussion started by: infiant
7 Replies

6. AIX

how to grep and compare timestamp in a file with the current date

I want to read a log file from a particular location.In the log file each line starts with timestamp.I need to compare the timestamp in the logfile with the current date.If the timpestamp in the log file is less than 4 hours then i need to read the file from that location.Below is the file... (1 Reply)
Discussion started by: achu
1 Replies

7. AIX

how to grep and compare timestamp in a file with the current date

I want to read a log file from a particular location.In the logfile , lines contains timestamp.I need to compare the timestamp in the logfile with the current date.If the timpestamp in the log file is less than 4 hours then i need to read the file from that location.Below is the file format.Please... (1 Reply)
Discussion started by: achu
1 Replies

8. Shell Programming and Scripting

File renaming with date timestamp

Hi, This is my script: #! /usr/bin/ksh cd /app/chdata/workflow/suppl/esoutput/spd/testing for file in /app/chdata/workflow/suppl/esoutput/spd/testing do sort *.txt | awk '{ file=substr($0,1,2)".txt"; print >> file }' ... (3 Replies)
Discussion started by: Sunitha_edi82
3 Replies

9. UNIX for Dummies Questions & Answers

get a file date/timestamp

Could someone tell me how to get the date/time (to the second) a file was last modified? I need to know if a file was modified in the last 30 seconds from the system date. I'm on AIX/unix 4.3 (3 Replies)
Discussion started by: alex31
3 Replies

10. Shell Programming and Scripting

Creating file with date/timestamp in it

I need to create a file through a c-shell script which contains only the date and time that the file was created. Does anyone know a simple way to do this? Thank you, Paula (7 Replies)
Discussion started by: ccpjr29
7 Replies
Login or Register to Ask a Question