need a search and replace string

A swapping-ground for Regular Expression syntax

need a search and replace string

Postby enhompe » Sat Feb 11, 2017 9:57 pm

I have song song titles where the artist's name is preceded by an upper case F. This used to mean "featuring" but after numerous processing the F is upper case and the first letter following (beginning the artist's name) is lower case. This I need to replace all the F's with ampersands and a space, followed by changing the next letter to uppercase.

current: Nick Cannon Fr Kelly - Gigolo
desired: Nick Cannon & R Kelly - Gigolo

current: J Status Frihanna - Roll It
desired: J Status & Rihanna - Roll It

Can this be done? Your help is greatly appreciated, as I hope you know!!! Thank you.
enhompe
 
Posts: 7
Joined: Sat Oct 25, 2014 4:30 pm

Re: need a search and replace string

Postby therube » Sun Feb 12, 2017 2:13 pm

You could try something like:

1:RegEx
Code: Select all
Match:  (.*) F(.*)
Replace:  \1 & \2


But you'll have to actually check your inputs because it will also find something like:

Ein Freundliches Wort Hat Meine Seele Beruhrt.mp3
Frou Frou - Breathe In.mp3

and incorrectly rename them to:

Ein & reundliches Wort Hat Meine Seele Beruhrt.mp3
Frou & rou - Breathe In.mp3
therube
 
Posts: 1314
Joined: Mon Jan 18, 2016 6:23 pm

Re: need a search and replace string

Postby enhompe » Mon Feb 13, 2017 5:57 pm

Is there a way to move all the affected files to a separate folder before I perform the operation? Then it would be easier to check them all afterward sand correct those mistakenly affected.
enhompe
 
Posts: 7
Joined: Sat Oct 25, 2014 4:30 pm

Re: need a search and replace string

Postby Admin » Tue Feb 14, 2017 12:18 am

Did you try Copy/Move to Location (13)? thanks
Admin
Site Admin
 
Posts: 2343
Joined: Tue Mar 08, 2005 8:39 pm


Return to Regular Expressions