Need help in sorting the file and copying


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help in sorting the file and copying
# 1  
Old 11-01-2011
Need help in sorting the file and copying

Hello Experts,

I have a requirement:

In a directory, four files are getting created on monthly basis, having timestamp in the end of every file. I want to arrange file in ascending order and copy the first file to other directory and after copying i want to remove it.

Example
-----------
Test_Directory
-File06302011
-File07312011
-File08312011
-File09302011

Copy File06302011 to some other location and after copying remove it from Test_Directory.

Please help
# 2  
Old 11-01-2011
When you say the files are getting created monthly basis, does it mean that each file created every month? or all of them created at once one for each month?

--ahamed
This User Gave Thanks to ahamed101 For This Post:
# 3  
Old 11-01-2011
Instead of copying and removing .. just move the file to the destination path ..
Code:
$ ls File* | sort -n | nawk '{if(NR==1) {print "mv "$0" /dest/path"}}' | sh

This User Gave Thanks to jayan_jay For This Post:
# 4  
Old 11-01-2011
If the files maintain the timestamp then try this...
Code:
ls -t Test_Directory/FILE* | tail -1 | xargs -I {} mv {} /your/destination

--ahamed
This User Gave Thanks to ahamed101 For This Post:
# 5  
Old 11-01-2011
Hi Ahamed,

Yes, the file is getting created on monthly basis....every month end a new file will be created and I have to move the oldest file to some other location.

Thanks a lot experts...
# 6  
Old 11-02-2011
Base on the file created each month, you can put below command in your cronjob, and it will automatically move the old files out of the test_directory.
Code:
find /test_directory -type f -mtime +90 -exec mv {} /new folder \;

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Copying a file to multiple other files using a text file as input

Hello, I have a file called COMPLIST as follows that contains 4 digit numbers.0002 0003 0010 0013 0015 0016 0022 0023 0024 0025 0027 0030 0031 0032 0033 0035 0038 0041 (3 Replies)
Discussion started by: sph90457
3 Replies

2. UNIX for Dummies Questions & Answers

Sorting data in file based on field in another file

Hi, I have two files, one of which I would like to sort based on the order of the data in the second. I would like to do this using a simple unix statement. My two files as follows: File 1: 12345 1 2 2 2 0 0 12349 0 0 2 2 1 2 12350 1 2 1 2 2 2 . . . File2: 12350... (3 Replies)
Discussion started by: kasan0
3 Replies

3. UNIX for Dummies Questions & Answers

Help with searching for a file in a directory and copying the contents of that file in a new file

Hi guys, I am a newbie here :wall: I need a script that can search for a file in a directory and copy the contents of that file in a new file. Please help me. :confused: Thanks in advance~ (6 Replies)
Discussion started by: zel2zel
6 Replies

4. Shell Programming and Scripting

sed command for copying the contents of other file replacing it another file on specifc pattern

We have 2 file XML files - FILE1.XML and FILE2.xml - we need copy the contents of FILE1.XML and replace in FILE2.xml pattern "<assignedAttributeList></assignedAttributeList>" FILE1.XML 1. <itemList> 2. <item type="Manufactured"> 3. <resourceCode>431048</resourceCode> 4. ... (0 Replies)
Discussion started by: balrajg
0 Replies

5. Shell Programming and Scripting

Finding & Moving Oldest File by Parsing/Sorting Date Info in File Names

I'm trying to write a script that will look in an /exports folder for the oldest export file and move it to a /staging folder. "Oldest" in this case is actually determined by date information embedded in the file names themselves. Also, the script should only move a file from /exports to... (6 Replies)
Discussion started by: nikosey
6 Replies

6. Shell Programming and Scripting

Copying only the file name

Hi I just want to copy the file name from the input file. Below is the code I have used but the answer comes with quotation . $ cat test.sh file_name=\'$1\' echo $file_name $ sh test.sh grants.dat 'grants.dat' How do I remove the quotation Thanks (2 Replies)
Discussion started by: Krishnaramjis
2 Replies

7. UNIX for Dummies Questions & Answers

Copying one file into another

I have two files, lets say file1.pun and file2.pun Now i need to copy the first 10 lines of file1.pun and paste them on the head of file2.pun without deleting the contents of file2.pun. I have to do this from command line only. Can u plz guide me in this regards (4 Replies)
Discussion started by: jasjot31
4 Replies

8. Filesystems, Disks and Memory

Strange difference in file size when copying LARGE file..

Hi, Im trying to take a database backup. one of the files is 26 GB. I am using cp -pr to create a backup copy of the database. after the copying is complete, if i do du -hrs on the folders i saw a difference of 2GB. The weird fact is that the BACKUP folder was 2 GB more than the original one! ... (1 Reply)
Discussion started by: 0ktalmagik
1 Replies

9. Shell Programming and Scripting

copying the csv file into different worksheets of xls file

Hi, I have a script which will generate three csv files. i want to copy the contents of these csv files into a .XLS file but in different worksheets. Can a this be done in the same script? :confused: Can Perl come to my help in coping the csv files into different worksheets of .XLS file ?... (0 Replies)
Discussion started by: nimish
0 Replies

10. Programming

copying a file

hello, i have to copy a file from one directory to another directory in linux. how to do this using a c function? kindly ans to my query. thanks (2 Replies)
Discussion started by: svh
2 Replies
Login or Register to Ask a Question