Read file name based on date


 
Thread Tools Search this Thread
Contact Us Post Here to Contact Site Administrators and Moderators Read file name based on date
# 1  
Old 08-18-2016
Read file name based on date

Hi,

I have file name as Example
Code:
extract_ces_v3_p044444rlt_20160514045705.txt.pgp
extract_ces_v3_p044444rlt_20160614049705.txt.pgp
extract_ces_v3_p044444rlt_20160714046705.txt.pgp

I have to read file name based on date(i.e) files with same date and copy to another directory in shell script.




Thanks,
Caba.

Last edited by rbatte1; 08-18-2016 at 07:18 AM.. Reason: Added CODE tags for file name list
# 2  
Old 08-18-2016
Hello caba_jones ,

I have a few to questions pose in response first:-
  • What have you tried so far?
  • What output/errors do you get?
  • What OS and version are you using?
Most importantly, What have you tried so far?

There are probably many ways to achieve most tasks, so giving us an idea of your style and thoughts will help us guide you to an answer most suitable to you so you can adjust it to suit your needs in future.


We're all here to learn and getting the relevant information will help us all.


Kind regards,
Robin
# 3  
Old 08-18-2016
i tried to extract the date using the below code but not able to,can you please check
Code:
#Script for copying files from src to dest based on same date and time
#!/bin/bash

#Script Variables
SPATH="/remote/home/folder1"
DPATH="/remote/home/folder2"
SUFFIX_ARG="*.txt"
ACTION_TIME=`date +'%Y%m%d' "%H:%M:%S:"`


echo "${ACTION_TIME} Starting copy task" 
find ${SPATH} -type f -name "${SUFFIX_ARG}" -print | while read path
do
   FN="${path##*/}" #extract the file name from the path
   temp=${FN#*_} 
  date=${temp%.txt.pgp} # trying to get the date alone 
   echo "this is the file name"$FN 
   ACTION_TIME=`date +"%Y%m%d %T"`
     if [ -e "${DPATH}/${FN}" ]   #if the destination file exists, skip it
   then
      echo "${ACTION_TIME} Skipped: File ${DPATH}/${FN} already exist"  
   else
      
	   cp "$path" "${DPATH}/${FN} ${ACTION_TIME}"  
	   ACTION_TIME=`date +"['%y%m%d' %T]:"`
	   echo "${ACTION_TIME} Copy ${FN} to ${DPATH} Complete"  
   fi
   echo "done copy"
done



Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!

Last edited by RudiC; 08-18-2016 at 12:28 PM.. Reason: Added/corrected CODE tags.
# 4  
Old 08-18-2016
Some comments (not necessarily in severity order or order of appearance):
- consider refraining from using variables named close to PATH (essential system variable for your session; used to locate commands!) so you don't mess up your session by accident.
- your first ACTION_TIME assignment has a syntax error in the date command.
- giving variables (date) identical names to commands may lead to confusion.
- what do you create the date variable for in the first place?
- consider using the recommended $(...) notation in lieu of the deprecated `...` for "command substitution".
- your find command won't find any of the files quoted in post#1 as the pattern in SUFFIX_ARG doesn't match.
- the test for existence is for a different file than the one actually copied, so probably pointless.

On top, the specification in post#1 is sparse by itself, and it is not improved by your second post. Why don't you take a step back, start over, and present your problem in a decent, precise, detailed way supported by samples?

Last edited by RudiC; 08-18-2016 at 01:43 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Read a file and send mail based on grep

Hi All, I am having a job and I need to send email when the job is running. On any other case (success,fail) I don't needed to send email. I check with BMC they told they dont have that in the version I am using. So I created a dependent job and grepped for the status and sent email. My... (1 Reply)
Discussion started by: arunkumar_mca
1 Replies

2. Shell Programming and Scripting

To take file based on date passed

Hi Guys, I have certain files in my directory which gets appended with dates something like this T1_aug17.txt T1_Aug17.txt T1_Sep17.txt config.txt T1 T2 my code: curr_date=`date -d "$date" +%Y-%m-%d` path=mydir for file in `cat config.txt` do final_file=$(ls $path/ | grep -i... (12 Replies)
Discussion started by: rohit_shinez
12 Replies

3. HP-UX

HP/UX command to pull file name/date based on date

HI, Can anyone tell me how to pull the date and file name separated by a space using the find command or any other command. I want to look through several directories and based on a date timeframe (find -mtime -7), output the file name (without the path) and the date(in format mmddyyyy) to a... (2 Replies)
Discussion started by: lnemitz
2 Replies

4. Shell Programming and Scripting

Script to determine Date,TotalFile,total size of file based on date

I have file listed like below -rw-r--r--+ 1 test test 17M Nov 26 14:43 test1.gz -rw-r--r--+ 1 test test 0 Nov 26 14:44 test2.gz -rw-r--r--+ 1 test test 0 Nov 27 10:41 test3.gz -rw-r--r--+ 1 test test 244K Nov 27 10:41 test4.gz -rw-r--r--+ 1 test test 17M Nov 27 10:41 test5.gz I... (5 Replies)
Discussion started by: krish2014
5 Replies

5. Shell Programming and Scripting

Help with ksh-to read ip file & append lines to another file based on pattern match

Hi, I need help with this- input.txt : L B white X Y white A B brown M Y black Read this input file and if 3rd column is "white", then add specific lines to another file insert.txt. If 3rd column is brown, add different set of lines to insert.txt, and so on. For example, the given... (6 Replies)
Discussion started by: prashob123
6 Replies

6. Shell Programming and Scripting

creating a file name based on date

I need to automate a weekly process of piping a directory list to a csv file. Normally I do ls -l > files_04182010.csv (04182010 being the date..) Can someome show me how I would script this, so that when the script is ran it grabs the current date and formats it and allows me to use that... (8 Replies)
Discussion started by: jeffs42885
8 Replies

7. UNIX for Dummies Questions & Answers

Truncating file based on date

Hi, I need to truncate a file based on date.Suppose i have a log file which is getting updated every date,i need to keep 7 days worth of data(like sysdate-7) and rest i want to truncate it.Can some help me? (5 Replies)
Discussion started by: Param0073
5 Replies

8. Shell Programming and Scripting

Split the file based on date value

Hi frnds, I have flat file as . Say : output-file1.txt Output-file2.txt (1 Reply)
Discussion started by: Gopal_Engg
1 Replies

9. Shell Programming and Scripting

Read a date value from other file.

My Situation is I have to read a date value from previuosly created file and need to increment the date in the newly created file. I need unix scripting for the above condtion. Thanx in advance. (3 Replies)
Discussion started by: chilli_taste
3 Replies

10. Shell Programming and Scripting

Read file based on condition

Hi Friends, Can any one help with this: I have a huge file with the format as A SAM 4637 B DEPT1 4758 MILAN A SMITH 46585 B DEPT2 5385 HARRYIS B SAMUL 63547 GEORGE B DANIEL 899 BOISE A FRES 736 74638 I have to read this file and write only the records that starts with "B" only ... (5 Replies)
Discussion started by: sbasetty
5 Replies
Login or Register to Ask a Question