Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

rename files Ax based on strings found in files Bx

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting rename files Ax based on strings found in files Bx
# 1  
Old 10-07-2009
rename files Ax based on strings found in files Bx
Hi,

I'm not very experienced in shell scripting and that's probably why I came across the following problem:

I do have several hundred pairs of text files (PF00x.spl and PF00x.shd) where the first file (PF00x.spl) needs to be renamed according a string that is included in the second file (PF00x.shd).

Example:

PF00x.shd contains a string (length varies from file to file; example would be: AB09098765 7 6 5) within the follwing keywords "bviwacsbviwacs" and "Adb"

The goal is to rename PF00x.spl to AB09098765 7 6 5.spl and so on for the remaining files.

I hope my description makes sense... any suggestions how I could solve that problem?

Thanks a lot!
# 2  
Old 10-07-2009
give some example lines from the second file rather than describing them
# 3  
Old 10-07-2009
Here you go (extract from PF001.shd):

å2›H&ýÊ   å2›H&ý b v i w a c s b v i w a c s s m u A B 4 6 2 6 6 7 _ 2 0 0 9 0 8 1 4 7 3 9 4 3 7 1 0 - B e r i c h t A d b P L F A d b \ \ P C 2 6 7 I W A C S

And I'm looking for the string marked bold.

Thanks,
# 4  
Old 10-07-2009
This works in ksh when run in the same directory as the target files: -

Code:
ls *.shd | while read FILE_NAME
do
        if [[ -w ${FILE_NAME%.*}.spl ]] ## Ignore any file with no .spl file
        then
                NEW_FILE_NAME=$( nawk ' BEGIN {
                        ## Spaces in target strings ????
                        first = "b v i w a c s b v i w a c s"   
                        last = "A d b"
                }
                ( $0 ~ first ) && ( $0 ~ last ) {
                        startm = index( $0, first ) + length( first )
                        endm = index( $0, last ) - 1
                        file_name = substr( $0, startm, endm - startm )
                } END {
                        ## Remove spaces from new file name
                        gsub( / /, "", file_name )              
                        print file_name
                } ' $FILE_NAME).spl

                ## Copy. change cp to mv if required
                cp ${FILE_NAME%.*}.spl $NEW_FILE_NAME           
        else
                echo "File ${FILE_NAME} has no matching .spl file"
        fi
done

Your first post had no spaces in the enclosing strings but your second did as well as having unprintable characters so I created a test file with spaces in as a worst case. Running the code as a script called "inch" with these files: -

Code:
TX5XN:/home/brad/forum/inch>ls -l
total 8
-rwxrwxrwx 1 brad root 682 2009-10-07 20:07 inch
-rw-r--r-- 1 brad root 143 2009-10-07 18:50 PF00x.shd
-rw-r--r-- 1 brad root   0 2009-10-07 19:37 PF00x.spl
-rw-r--r-- 1 brad root   0 2009-10-07 19:59 PF01x.shd

Gave this output: -

Code:
TX5XN:/home/brad/forum/inch>inch
File PF01x.shd has no matching .spl file

TX5XN:/home/brad/forum/inch>ls -l
total 8
-rwxrwxrwx 1 brad root 682 2009-10-07 20:07 inch
-rw-r--r-- 1 brad root 143 2009-10-07 18:50 PF00x.shd
-rw-r--r-- 1 brad root   0 2009-10-07 19:37 PF00x.spl
-rw-r--r-- 1 brad root   0 2009-10-07 19:59 PF01x.shd
-rw-r--r-- 1 brad root   0 2009-10-07 20:11 smuAB462667_2009081473943710-Bericht.spl

# 5  
Old 10-07-2009
TX5XN:/home/brad/forum/inch>ls -l
total 8
-rwxrwxrwx 1 brad root 682 2009-10-07 20:07 inch
-rw-r--r-- 1 brad root 143 2009-10-07 18:50 PF00x.shd
-rw-r--r-- 1 brad root 0 2009-10-07 19:37 PF00x.spl
-rw-r--r-- 1 brad root 0 2009-10-07 19:59 PF01x.shd
# 6  
Old 10-07-2009
You're going to be on the short end of a banning any minute now...
# 7  
Old 10-07-2009
Aha
Ok sir large
I am a Palestinian
I love forums and the U.S.
Ahan recorded heck with you
You want a kick me out Thank you
PDC kept Thank you too
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to pass strings from a list of strings from another file and create multiple files?

Hello Everyone , Iam a newbie to shell programming and iam reaching out if anyone can help in this :- I have two files 1) Insert.txt 2) partition_list.txt insert.txt looks like this :- insert into emp1 partition (partition_name) (a1, b2, c4, s6, d8) select a1, b2, c4, (2 Replies)
Discussion started by: nubie2linux
2 Replies

2. UNIX for Beginners Questions & Answers

Rename files based on simple text file

Hello! New here although not completely new to Unix. I wonder how I could rename files based on the data found in a simple textfile. It goes like this: I have 4 files 1 ldfgkkfjslkdfjsldkfjsf.wav 2 nndsdflksdjf.wav 3 sdflksjdf jjsdflsdfl.wav 4 dkadsdddd.wav Textfile.txt looks like... (14 Replies)
Discussion started by: Oortone
14 Replies

3. Shell Programming and Scripting

SBATCH trinity for multiple files and rename/move the output files

Hey guys, I have wrote the following script to apply a module named "trinity" on my files. (it takes two input files and spit a trinity.fasta as output) #!/bin/bash -l #SBATCH -p node #SBATCH -A <projectID> #SBATCH -n 16 #SBATCH -t 7-00:00:00 #SBATCH --mem=128GB #SBATCH --mail-type=ALL... (1 Reply)
Discussion started by: @man
1 Replies

4. Shell Programming and Scripting

Rename files based on name in text file

Hello, I have a text file "file.list" with the contents below. file1 filename1 file2 filename2 file3 filename3 file1, file2 and file3 are files existing in the same directory as the text file file.list. I want to rename file1 to filename1, file2 to filename2, as show in the text... (1 Reply)
Discussion started by: james2009
1 Replies

5. UNIX for Dummies Questions & Answers

Rename files based on a list

Hi, I have a directory with a lot of files like this: a.bam b.bam c.bam I like to rename these files based on a list where the name of the files in the first column will be replasced by the names in the second column. Here is my list which is a tab-delimited text file: a x b y c ... (4 Replies)
Discussion started by: a_bahreini
4 Replies

6. Shell Programming and Scripting

Script to unzip files and Rename the Output-files

Hi all, I have a many folders with zipped files in them. The zipped files are txt files from different folders. The txt files have the same names. If i try to find . -type f -name "*.zip" -exec cp -R {} /myhome/ZIP \; it fails since the ZIP files from different folders have the same names and... (2 Replies)
Discussion started by: pmkenya
2 Replies

7. Shell Programming and Scripting

Finding/replacing strings in some files based on a file

Hi, We have a file (e.g. a .csv file, but could be any other format), with 2 columns: the old value and the new value. We need to modify all the files within the current directory (including subdirectories), so find and replace the contents found in the first column within the file, with the... (9 Replies)
Discussion started by: Talkabout
9 Replies

8. UNIX for Dummies Questions & Answers

rename files based on their respective directory name

I have a number of files in directories labeled like this: /Data/tr_gray/tr_DTI/dti_FA.nii.gz (the brackets here represent a range of number that the files are labeled with) I need to rename each dti_FA.nii.gz file according to the name of the folder it resides in. For example, the file ... (3 Replies)
Discussion started by: tk0034
3 Replies

9. Shell Programming and Scripting

How to strip ^M at end of each files for all files found in current directory

I am trying to use a loop to strip of the funny character ^M at the end of all lines in each file found in current directory and I have used the following in a script: find . -type f -name '*.txt' | while read file do echo "stripping ^M from ..." ex - "$file" > $tempfile %s/^M//g wq! # mv... (4 Replies)
Discussion started by: bisip99
4 Replies

10. Shell Programming and Scripting

Rename files/directories based on their name

i have hundreds of directories that have to be renamed. the directory structure is fairly uniform which makes the scripting a little simpler. suppose i have many directories like this */*/*/*abc* (in other words i have similar directory names 3 dirs deep that all contain the pattern abc in... (8 Replies)
Discussion started by: quantumechanix
8 Replies
Login or Register to Ask a Question