Find and replace multiple words by using Excel file or txt

Bulk Rename Utility How-To's

Find and replace multiple words by using Excel file or txt

Postby Jakov » Sun Jan 26, 2025 4:19 am

Hi,
I want to find and replace multiple words according to Excel or txt file that contains two columns (find and replace), each column contains the desired words to be found and replaced.
Is this possible with BRU?
Thanks
Jakov
 
Posts: 60
Joined: Sat May 23, 2020 1:29 am

Re: Find and replace multiple words by using Excel file or txt f

Postby TheGhost78 » Sun Jan 26, 2025 7:05 am

Actions > Import Rename-Pairs (CSV)
TheGhost78
 
Posts: 173
Joined: Fri Jul 19, 2024 11:25 am

Re: Find and replace multiple words by using Excel file or txt f

Postby Jakov » Sun Jan 26, 2025 12:17 pm

Thanks, but as I know that Rename-Pairs requires custom pattern
OldName.extension | NewName.extension
Ex: Track001.mp3|Headlong.mp3
It's not what I want, I want to find and replace certain words in file name
suppose the file name is "Back up your personal data to prevent data loss", so I want search for "personal" and "data" and replace it with "unique" and "info" and so on.
making csv file with only old and new words doesn't work with Rename-Pairs such as
personal,unique
data,info
So how to fulfills my requirement?
Thanks
Jakov
 
Posts: 60
Joined: Sat May 23, 2020 1:29 am

Re: Find and replace multiple words by using Excel file or txt f

Postby TheGhost78 » Sun Jan 26, 2025 12:25 pm

Use Replace (3)
Click the two horizontal lines next to 'With' and you can add several find and replace terms.
TheGhost78
 
Posts: 173
Joined: Fri Jul 19, 2024 11:25 am

Re: Find and replace multiple words by using Excel file or txt f

Postby Jakov » Sun Jan 26, 2025 6:08 pm

Please I can't find the two horizontal lines next to 'With' , where it?
Jakov
 
Posts: 60
Joined: Sat May 23, 2020 1:29 am

Re: Find and replace multiple words by using Excel file or txt f

Postby TheGhost78 » Sun Jan 26, 2025 10:48 pm

Under the section called Replace (3) - left of centre.
Next line down is a field called Replace.
Next line down is a field called With.
To the right of the word 'With' is a button that looks like an equals (=) sign.
It is above the word 'Match' in for the 'Match Case' tickbox.
TheGhost78
 
Posts: 173
Joined: Fri Jul 19, 2024 11:25 am


Return to How-To