# Stripping Duplicate Data from TITLE Field

**URL:** https://community.mp3tag.de/t/stripping-duplicate-data-from-title-field/48909
**Category:** General Discussion
**Created:** [May 10, 2020, 11:04pm UTC](https://community.mp3tag.de/t/stripping-duplicate-data-from-title-field/48909 "2020-05-10T23:04:20Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![jsabrown](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/j/f0a364/32.png) [@jsabrown](https://community.mp3tag.de/u/jsabrown)
#### Post date: [May 10, 2020, 11:04pm UTC](https://community.mp3tag.de/t/stripping-duplicate-data-from-title-field/48909/1 "2020-05-10T23:04:20Z")

</div>

So I've got about 1500 mp3s that have the TITLE field as such:

Song Title by [Artist]  
where [Artist] is the data in the ARTIST field

So if the song title is "Africa by Toto", I want to change it to "Africa". x1500  
But I don't want to change "Stand by Me" to "Stand"

Anybody offer a little help? I've been looking through community posts for the last hour or so, but I still don't understand how I could do that, and it SEEMS like something I should be able to readily do.

---

<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: [May 11, 2020, 4:32am UTC](https://community.mp3tag.de/t/stripping-duplicate-data-from-title-field/48909/2 "2020-05-11T04:32:53Z")

</div>

> [@jsabrown](#):
>
> I want to change it to "Africa". x1500  
> But I don't want to change "Stand by Me" to "Stand"

I don't think that this works without a little help what the artist may look like.  
So: do you find that what follows the "by" in the field ARTIST?  
Then you could filter for  
`%title% HAS " by " AND NOT "$strstr(%title%,%artist%)" IS 0`  
and then run an action of the type "Guess value" with  
Source: %title%  
Target Pattern: %title% by %dummy%

---

<div class="post-metadata">

### Author: ![jsabrown](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/j/f0a364/32.png) [@jsabrown](https://community.mp3tag.de/u/jsabrown)
#### Post date: [May 11, 2020, 10:02pm UTC](https://community.mp3tag.de/t/stripping-duplicate-data-from-title-field/48909/3 "2020-05-11T22:02:37Z")

</div>

Perfect! Thank you very much!

I was able to reverse-engineer what you wrote and it provided me insight as to how the tool works. Once I understood what it was trying to do, I tried it out and it worked. What would have take me 6 hours to do manually got done in seconds (plus a couple days of head scratchin, but that doesn't count).

---

<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: [June 10, 2020, 10:02pm UTC](https://community.mp3tag.de/t/stripping-duplicate-data-from-title-field/48909/4 "2020-06-10T22:02:42Z")

</div>

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