replacing something in a field with another field

I want to make an action so that if the album has a certain character in it (doesn't matter which) it will replace the character with the what is in the Title (%Title%). But if there is normal text in the album it leaves it as such.

i tried using replace Field-album original-# replace with-%title% but it did not work.

can anyone please help?!

Can't you show a concrete example please?

In general:
Create an action of the type "Format value" for ALBUM
Format string: $replace(%album%,original-#,%title%)

For example if the title was "Sugar (EDX Remix)" i would manually type the album in as "Sugar". but if the title was "Going Crazy" and i wanted the album to be the same, i would just enter the album as "#". then i would want to run an action that would change the album to whatever the title is, if the album is "#". but the action would leave the album as is, if i had already entered text e.g. "Sugar".

Hope this makes sense, thanks

Well, yes and no.

If you have empty ALBUM fields and you want to copy the title into the album field, the use a filter
album MISSING
and then create an action of the type "Format value" for ALBUM
Format string: %title%

You could modify my example to
Format string: $replace(%album%,#,%title%)

that does help thank you but i was wondering if you knew a way so that it would copy the title to album only when it is empty and leave it as it is when it already has an album.

This should be the case if you apply the filter.
And: have you tried it with already filled album fields?
As long as you do not have the search-character in the field, nothing should happen.

Convert "Tag - Tag" ... or ... Action "Format value" Field ......: ALBUM Formatstring: $if($eql(%ALBUM%,'#'),%TITLE%,%ALBUM%)

DD.20150916.1054.CEST