Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Renaming Files Based on Contents
Top Forums Shell Programming and Scripting Renaming Files Based on Contents Post 302387459 by DerangedNick on Saturday 16th of January 2010 01:38:54 AM
Old 01-16-2010
Renaming Files Based on Contents
Hello everyone,

I currently have a situation which is causing me some issues for keeping up with certain files. I will explain this to the best of my abilities.

I have a list of files as follows

50_REPORT_1111 - file contains the word Car
50_REPORT_2222 - file contains the word House
50_REPORT_3333 - file contains the word Dog
50_REPORT_4444 - file contains the word Apple
50_REPORT_5555 - file contains the word Orange
50_REPORT_6666 - file contains the word Grape

As you can see the name between the _ and the _ are all the same, however each file contains different information. The files are all text.

So what i'd like to do is some sort of Unix script that would go through and read the files if they contained "_REPORT_" in the file name and after the first time it matched the word Car while reading the file, it would then rename the file to 50_REPORT.CAR_1111 and then continue searching the specified directory for another file that contains _REPORT_ until there are no more left and all of the files have been renamed.

I am honestly not sure where to start this, so if someone could at least point me in the right direction I might be able to figure it out from there.

I hope what I said makes sense.

Thank you for your time reading this.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove lines based on contents of another file

So, this issue is driving me nuts! I was hoping to get a lending hand here... I have 2 files: file1.txt contains: this is example1 this is example2 this is example3 this is example4 this is example5 file2.txt contains: example3 example5 Basically, I need a script or command to... (4 Replies)
Discussion started by: bashshadow1979
4 Replies

2. Shell Programming and Scripting

Merging files based on the contents

Hi, I have a file f1 having the contents as below select (<condn>) from dual I have another file f2 having the contents as below 1, 2, 3 I want to replace <condn> in f1 with the contents of f2 I tried using sed like this sed "s:<condn>:`cat f2`:g" f1 The above command resulted in sed:... (3 Replies)
Discussion started by: mr_manii
3 Replies

3. Shell Programming and Scripting

Manipulating word based off of contents

Hello everyone, my first post here, please feel free to inform me if my question can be better formatted so my future posts may be more clear. I have a large text file which I need parsed in one specific way, I have done the rest of the processing, I am simply lacking the last aspect of such. ... (8 Replies)
Discussion started by: ryanfx
8 Replies

4. Shell Programming and Scripting

Renaming files based on data in a spreadsheet

I have a spreadsheet in a folder that looks like this: Sector1...Sector2...Sector3...Sector4...Sector5...Sector6...Sector7 SomeID....Title.......SomeID...SomeID....SomeID...SomeID....SomeID OtherID...MyTitle....SomeID...SomeID....SomeID...SomeID....SomeID... (7 Replies)
Discussion started by: Xterra
7 Replies

5. UNIX for Dummies Questions & Answers

count values based on contents of another file

Hello, I have two files as shown below: test1 678 679 689 690 710 test2 1 678 654 800 676 791 689 900 I want to get a count of lines from test2 whose columns bound the values in test1 I tried running the code below; however am getting wrong results. (3 Replies)
Discussion started by: Gussifinknottle
3 Replies

6. Shell Programming and Scripting

Splitting large file and renaming based on field

I am trying to update an older program on a small cluster. It uses individual files to send jobs to each node. However the newer database comes as one large file, containing over 10,000 records. I therefore need to split this file. It looks like this: HMMER3/b NAME 1-cysPrx_C ACC ... (2 Replies)
Discussion started by: fozrun
2 Replies

7. Shell Programming and Scripting

Concatenating many files based on a specific column contents

Dear all, I have many files(.csv) in a directory. I want to concatenate the files which have similar entries in a particular column and save into a new file like result_datetime.csv etc. One example file is like below. Sno,Step,Data1,Data2,Data3 etc. 1,0,2,3,4 2,1,3,4,5 3,2,0,1,1 ... (4 Replies)
Discussion started by: ks_reddy
4 Replies

8. Shell Programming and Scripting

File comparison based on contents

Hi I have 2 files 1.del ---- 1,2,3,4,5 1,2,3,4,4 1,1,1,1,2 2.del ---- 1,2,3,4,5 1, 1,2,3,4,4 1,1,1,1,2 I need to compare the above two files in unix, as in the output should only tell the difference in contents as I should get only the line 1 ( from 2.del) , rest all lines are... (4 Replies)
Discussion started by: Ethen561
4 Replies

9. Shell Programming and Scripting

Computing difference based on line contents

I have the following awk script set up to copy the contents of a line that contains 0008 in each line that contains values of 1895 through 2012. awk -v OFS=" " '{val=0+substr($1,length($1)-3,4);if(val==0008){print;$1=x;y=$0}else{if(val>=1895&&val<=2012){print $1 y}else{print}}}' Output... (7 Replies)
Discussion started by: ncwxpanther
7 Replies

10. Shell Programming and Scripting

How to remove a line based on contents of the first column?

Good day all. Using basic UNIX/Linux tools, how would you delete a line based on a character found in column 1? For example, if the CITY name contains an 'a' or 'A', delete the line: New York City; New York Los Angeles; California Chicago; Illinois Houston; Texas Philadelphia;... (3 Replies)
Discussion started by: BRH
3 Replies

LEARN ABOUT DEBIAN

sql::reservedwords::mysql

SQL::ReservedWords::MySQL(3pm)				User Contributed Perl Documentation			    SQL::ReservedWords::MySQL(3pm)

NAME

       SQL::ReservedWords::MySQL - Reserved SQL words by MySQL

SYNOPSIS

	  if ( SQL::ReservedWords::MySQL->is_reserved( $word ) ) {
	      print "$word is a reserved MySQL word!";
	  }

DESCRIPTION

       Determine if words are reserved by MySQL.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either MySQL 3.2, 4.0, 4.1, 5.0 or 5.1.

       is_reserved_by_mysql3( $word )
	   Returns a boolean indicating if $word is reserved by MySQL 3.2.

       is_reserved_by_mysql4( $word )
	   Returns a boolean indicating if $word is reserved by either MySQL 4.0 or 4.1.

       is_reserved_by_mysql5( $word )
	   Returns a boolean indicating if $word is reserved by either MySQL 5.0 or 5.1.

       reserved_by( $word )
	   Returns a list with MySQL versions that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_mysql3
       is_reserved_by_mysql4
       is_reserved_by_mysql5
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords

       <http://dev.mysql.com/doc/>

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28					    SQL::ReservedWords::MySQL(3pm)
All times are GMT -4. The time now is 02:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy