Rename file using partial match to another


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Rename file using partial match to another
# 8  
Old 10-24-2019
I'm not sure I understand completly but in f1 the same IonCode may appear multiple times. However, the value in uniq is always unique and the each IonCode above each uniq unill the newline in f1 will be found in the data as a pair. That is in f1 IonCode_0404 but in data IonCode_0404.bam and IonCode_0404.bam.bai. In f1 IonCode_0402 but in data IonCode_0402.bam and IonCode_0402.bam.bai.
Both IonCode pairs are renamed with the $2 values from each matching IonCode above uniq with _test after it. Thank you very much Smilie.

Last edited by cmccabe; 10-24-2019 at 06:12 PM..
# 9  
Old 10-24-2019
Quote:
Originally Posted by cmccabe
I'm not sure I understand completly but in f1 the same IonCode may appear multiple times. However, the value in uniq is always unique
That is not the case in the demo f1 from post #1 red uniq is duplicated:

Code:
IonCode_0404 00-0000-xxx-xxx-xxx
IonCode_0402 11-1111-yy-yy-yyy
R_2019_00_00_00_00_00_xxxx_xx1-127-xxx_xxx_xxx_xxx_xx_xx_xx

IonCode_0402 22-2222-zz-zzzz-zzz
R_2019_00_00_00_00_00_xxxx_xx1-126-xxx_xxx_xxx_xxx_xx_xx_xx

IonCode_0404 10-0000-aa-aa-aa
IonCode_0412 55-1111-bb-bbb-bbb
R_2019_00_00_00_00_00_xxxx_xx1-127-xxx_xxx_xxx_xxx_xx_xx_xx

This User Gave Thanks to Chubler_XL For This Post:
# 10  
Old 10-24-2019
My apologies, I have corected the typo in post 1 and here as well. All 3 uniq values in f1 will always be different I just transcribed them wrong. Line 3 (the duplicate) will never be there (computers make less mistakes) . Thank you Smilie.

Code:
IonCode_0404 00-0000-xxx-xxx-xxx
IonCode_0402 11-1111-yy-yy-yyy
R_2019_00_00_00_00_00_xxxx_xx1-127-xxx_xxx_xxx_xxx_xx_xx_xx

IonCode_0402 22-2222-zz-zzzz-zzz
R_2019_00_00_00_00_00_xxxx_xx1-126-xxx_xxx_xxx_xxx_xx_xx_xx

IonCode_0404 10-0000-aa-aa-aa
IonCode_0412 55-1111-bb-bbb-bbb
R_2019_00_00_00_00_00_xxxx_xx1-120-xxx_xxx_xxx_xxx_xx_xx_xx

# 11  
Old 10-25-2019
I put an echo "These are the files:" $file statement and the files in data before the script executes are:
Code:
These are the files: IonCode_0402_xxx.xxx_xxx.bam
These are the files: IonCode_0402_xxx.xxx_xxx.bam.bai
These are the files: IonCode_0404_xxx.xxx_xxx.bam
These are the files: IonCode_0404_xxx.xxx_xxx.bam.bai

after the script executes:
Code:
00-0000-xxx-xxx-xxx IonCode_0402 11-1111-yy-yy-yyy IonCode_0402 22-2222-zz-zzzz-zzz IonCode_0404 10-0000-aa-aa-aa IonCode_0412 55-1111-bb-bbb-bbb_test.bam
00-0000-xxx-xxx-xxx IonCode_0402 11-1111-yy-yy-yyy IonCode_0402 22-2222-zz-zzzz-zzz IonCode_0404 10-0000-aa-aa-aa IonCode_0412 55-1111-bb-bbb-bbb_test.bam.bai
IonCode_0402_xxx.xxx_xxx.bam
IonCode_0402_xxx.xxx_xxx.bam.bai

Thank you Smilie.
# 12  
Old 10-25-2019
Don't know what that "after the script executes" is showing. Are your filenames ending up with spaces in the etc. like shown above?

Here is the script I'm using:

Code:
dir=/path/to/run/
for run in "$dir"/R_2019* ; do  ## # matching "R_2019*" to operate on desired directory and expand
  uniq=${run##*/}  ## store run with no path as s5
  while read from to
  do
     (
       cd "$dir"/"$uniq"/data
       for file in *.bam*
       do
          newname=${file/$from*.bam/${to}_test.bam}
          [ -f "$file" ] && [ "$newname" != "$file" ] && mv "$file" "$newname"
       done
     )
  done <<<$(
     awk -F '\n' -v RS="" -v ref="$uniq" '
         $0 ~ ref {
             d=split($0, val);
             for(i=1;i<d;i++) print val[i];
          }' "$dir"/f1
  )  ## loop through f1 for unique run and populate from and to
done

And here is my test:
Code:
$ find /path/to/run -type f -print
/path/to/run/f1
/path/to/run/R_2019_00_00_00_00_00_xxxx_xx1-126-xxx_xxx_xxx_xxx_xx_xx_xx/data/IonCode_0402_xxx.xxx_xxx.bam
/path/to/run/R_2019_00_00_00_00_00_xxxx_xx1-126-xxx_xxx_xxx_xxx_xx_xx_xx/data/IonCode_0402_xxx.xxx_xxx.bam.bai
/path/to/run/R_2019_00_00_00_00_00_xxxx_xx1-127-xxx_xxx_xxx_xxx_xx_xx_xx/data/IonCode_0404_xxx.xxx_xxx.bam
/path/to/run/R_2019_00_00_00_00_00_xxxx_xx1-127-xxx_xxx_xxx_xxx_xx_xx_xx/data/IonCode_0404_xxx.xxx_xxx.bam.bai
$ ./cmccabe_rename 
$ find /path/to/run -type f -print
/path/to/run/f1
/path/to/run/R_2019_00_00_00_00_00_xxxx_xx1-126-xxx_xxx_xxx_xxx_xx_xx_xx/data/22-2222-zz-zzzz-zzz_test.bam
/path/to/run/R_2019_00_00_00_00_00_xxxx_xx1-126-xxx_xxx_xxx_xxx_xx_xx_xx/data/22-2222-zz-zzzz-zzz_test.bam.bai
/path/to/run/R_2019_00_00_00_00_00_xxxx_xx1-127-xxx_xxx_xxx_xxx_xx_xx_xx/data/00-0000-xxx-xxx-xxx_test.bam
/path/to/run/R_2019_00_00_00_00_00_xxxx_xx1-127-xxx_xxx_xxx_xxx_xx_xx_xx/data/00-0000-xxx-xxx-xxx_test.bam.bai

This User Gave Thanks to Chubler_XL For This Post:
# 13  
Old 10-25-2019
After the rename scripts runs then only one pair of the files is renamed with both values in it, with a space in between. This is shown in the above, but im not sure why. Your output looks good. Thank you Smilie.
# 14  
Old 10-26-2019
Here is what I get:


with echo mv
Code:
mv IonCode_0402_xxx.xxx_xxx.bam _test.bam
mv IonCode_0402_xxx.xxx_xxx.bam.bai _test.bam.bai
mv IonCode_0404_xxx.xxx_xxx.bam _test.bam
mv IonCode_0404_xxx.xxx_xxx.bam.bai _test.bam.bai

with mv
Code:
_test.bam
_test.bam.bai

Thank you Smilie.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash to rename portion of file using match to another

In the portion of bash below I am using rename to match the $id variable to $file and when a match (there will alwsys be one) is found then the $id is removed from each bam and bam.bai in $file and _test is added to thee file name before the extension. Each of the variables is set correctly but... (3 Replies)
Discussion started by: cmccabe
3 Replies

2. Shell Programming and Scripting

awk to update file based on partial match in field1 and exact match in field2

I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output. $1 in database.txt will be in list.txt as a partial match. $2 of database.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies

3. Shell Programming and Scripting

Partial Match and Replace

Hi, I have a tab delimited text file like this one. I need to do a partial match of a particular cell and then replace matches with an empty cell. So here is a sample: Smith FordMustang ChevroletCamaro Miller FordFiesta Jones KiaSorrento Davis ChevroletCamaro Johnson ToyotaHighlander I... (4 Replies)
Discussion started by: mikey11415
4 Replies

4. Shell Programming and Scripting

Rename files to match file list pattern

Hi All, I have 100 folders with the first delimiter has a unique name i.e (123_hello and 575_hello) and each folder have atlist 1000 plus files with naming convention i.e (575_hello_1.iso ... 575_hello_1000.iso). 575_hello/575_hello_1.iso 575_hello/575_hello_2.iso 575_hello/575_hello_3.iso... (8 Replies)
Discussion started by: lxdorney
8 Replies

5. Shell Programming and Scripting

Rename specific file extension in directory with match to another file in bash

I have a specific set (all ending with .bam) of downloaded files in a directory /home/cmccabe/Desktop/NGS/API/2-15-2016. What I am trying to do is use a match to $2 in name to rename the downloaded files. To make things a more involved the date of the folder is unique and in the header of name... (1 Reply)
Discussion started by: cmccabe
1 Replies

6. Shell Programming and Scripting

Match partial text

I posted the incorrect files yesterday and apologize. I also modified the awk script but with no luck. There are two text files in the zip (name.txt and output.txt). I am trying to match $2 in name.txt with $1 in output.txt and if they match then $1 of name.txt is copied to $7 of output.txt. ... (7 Replies)
Discussion started by: cmccabe
7 Replies

7. UNIX for Dummies Questions & Answers

How to substitute for the partial match?

Hi I have a question and hope I can get answer here. Thank you in advance. I have two files: file1: aa X bb Y cc Z file2: cc A bb B dd C aa D bb E If the 1st column match in both file1 and file2, the 2nd column in file2 will be replaced by the 2nd column in file1. If there is no... (2 Replies)
Discussion started by: yuejian
2 Replies

8. UNIX for Dummies Questions & Answers

Partial match in two files then substitute

Hi, I was trying to figure this out but failed so I hope someone here can help me, thank you in advance. I have two files. file1: aa M bb N cc O dd P ee Q file2: aa A_87_P254063 cc A_87_P016532 bb A_87_P104793 dd A_87_P055331 ee A_87_P059706 aa A_87_P071636 ee A_87_P028302... (2 Replies)
Discussion started by: yuejian
2 Replies

9. Shell Programming and Scripting

Using grep returns partial matches, I need to get an exact match or nothing

I’m trying to modify someone perl script to fix a bug. The piece of code checks that the zone name you want to add is unique. However, when the code runs, it finds a partial match using grep, and decides it already exists, so the “create” command exits. $cstatus = `${ZADM} list -vic | grep... (3 Replies)
Discussion started by: TKD
3 Replies

10. Shell Programming and Scripting

awk partial match and filter records

Hi, I am having file which contains around 15 columns, i need to fetch column 3,12,14 based on the condition that column 3 starts with 40464 this is the sample data how to achieve that (3 Replies)
Discussion started by: aemunathan
3 Replies
Login or Register to Ask a Question