# Automate the REPLACE action

**URL:** https://community.mp3tag.de/t/automate-the-replace-action/63706
**Category:** Support
**Created:** [February 7, 2024, 10:14am UTC](https://community.mp3tag.de/t/automate-the-replace-action/63706 "2024-02-07T10:14:57Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Ian\_Werich](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/i/9de0a6/32.png) [@Ian\_Werich](https://community.mp3tag.de/u/Ian_Werich)
#### Post date: [February 7, 2024, 10:14am UTC](https://community.mp3tag.de/t/automate-the-replace-action/63706/1 "2024-02-07T10:14:57Z")

</div>

Hi everyone,

I need to edit a large number of artist names in the ALBUMARTlST field that are currently in the format FIRSTNAMELAST, i.e. without separator space (e.g. MichaelJackson).  
I know I can do the job through the REPLACE action, but I was wondering if there is a way to automate this task, for example by providing MP3Tag with the list (in xls format?) of names to be corrected and new values to be replaced.

Thank you!  
Ian

---

<div class="post-metadata">

### Author: ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [February 7, 2024, 10:21am UTC](https://community.mp3tag.de/t/automate-the-replace-action/63706/2 "2024-02-07T10:21:14Z")

</div>

If you want to insert a space in

> [@Ian\_Werich](#):
>
> MichaelJackson

so that it becomes  
`Michael Jackson`

then try an action of the type "Format value" or Convert\>Tag-Tag for ALBUMARTIST  
Format string: `$regexp(%albumartist%,(\l)(\u),$1 $2)`

---

<div class="post-metadata">

### Author: ![Ian\_Werich](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/i/9de0a6/32.png) [@Ian\_Werich](https://community.mp3tag.de/u/Ian_Werich)
#### Post date: [February 7, 2024, 10:27am UTC](https://community.mp3tag.de/t/automate-the-replace-action/63706/3 "2024-02-07T10:27:41Z")

</div>

Thank you very much!

Maybe I've oversimplified the task I have to handle.

The names I have to put the space in are all in uppercase format, so I guess the action you suggested might not work.

Just to be precise and always referring the example of Michael Jackson, the name I have to deal with is written MICHAELJACKSON.

Ian

---

<div class="post-metadata">

### Author: ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [February 7, 2024, 10:35am UTC](https://community.mp3tag.de/t/automate-the-replace-action/63706/4 "2024-02-07T10:35:21Z")

</div>

> [@Ian\_Werich](#):
>
> so I guess the action you suggested might not work.

Indeed.  
That action relied on the pattern of a lower case character followed by an upper case character.

If you have to create a list of found spelling vs. correct spelling anyway, then I would think that filtering and sorting goes just as quickly and you save yourself the bother of thinking of a format with which you can import the list.  
So the procedure would be:  
Filter for a name  
Select all the files  
Enter the correct name in the tag panel  
Save the modification.

Perhaps an initial filter helps:  
`NOT %albumartist% HAS " "`

---

<div class="post-metadata">

### Author: ![Ian\_Werich](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/i/9de0a6/32.png) [@Ian\_Werich](https://community.mp3tag.de/u/Ian_Werich)
#### Post date: [February 7, 2024, 10:38am UTC](https://community.mp3tag.de/t/automate-the-replace-action/63706/5 "2024-02-07T10:38:21Z")

</div>

As usual, a good suggestion!

Thank you very much!  
Ian

---

<div class="post-metadata">

### Author: ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)
#### Post date: [March 8, 2024, 10:39am UTC](https://community.mp3tag.de/t/automate-the-replace-action/63706/6 "2024-03-08T10:39:00Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
