# Merging two fields and blanking the second one **URL:** \ **Category:** Support\ **Created:** [May 16, 2023, 4:30pm UTC](https://community.mp3tag.de/t/merging-two-fields-and-blanking-the-second-one/60998 "2023-05-16T16:30:21Z")\ **Posts on this page:** 8\ **Page:** 1
**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:** [May 16, 2023, 4:30pm UTC](https://community.mp3tag.de/t/merging-two-fields-and-blanking-the-second-one/60998/1 "2023-05-16T16:30:21Z")
Hi everyone, I've readen some suggestion to merge a field into another using "Format Value" but I haven't find suggestion to set blank one of the merged field. For example, I would like to merge the fields "Artist" and "Albumartist" into "Artist" to get a result such as: **Enrique Rodriguez, Armando Moreno** (where Enrique Rodriguez is the Artist and Armando Moreno is the Albumartist). I would like to adjust the action so that the field "Albumartist" is blanked at the end of the action. Thank you in advance. Ian ---
**Author:** ![MotleyG](https://community.mp3tag.de/user_avatar/community.mp3tag.de/motleyg/32/440_2.png) [@MotleyG](https://community.mp3tag.de/u/MotleyG)\ **Post date:** [May 16, 2023, 4:48pm UTC](https://community.mp3tag.de/t/merging-two-fields-and-blanking-the-second-one/60998/2 "2023-05-16T16:48:43Z")
You would do this with two actions. First, use Format Value (or the converter tool for Tag\>Tag will work as well). Once you have made the changes to the files in question, you can highlight all of them and delete the Albumartist tag in the tag panel, or in the extended tag window. But is this truly intended? The Albumartist field is a common requirement for most music managers and players to properly sort complete albums. ---
**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 16, 2023, 4:49pm UTC](https://community.mp3tag.de/t/merging-two-fields-and-blanking-the-second-one/60998/3 "2023-05-16T16:49:51Z")
Whatever the purpose may be to > [@Ian\_Werich](#): > > merge the fields "Artist" and "Albumartist" into "Artist" as most players need ALBUMARTIST to group albums together... Try an action of the type "Guess value" Source: `==%albumartist%, %artist%` Target pattern: `%albumartist%==%artist%` ---
**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:** [May 17, 2023, 11:55pm UTC](https://community.mp3tag.de/t/merging-two-fields-and-blanking-the-second-one/60998/4 "2023-05-17T23:55:01Z")
Thank you very much for the suggestion. I am aware that the main music managers/players have the "album artist" field, but I have not been able to take advantage of this possibility. Let me explain. Until today, I have used MediaMonkey for my tango dj activity; it offers many possibilities for customizing the music library, but over time it has proved to be a bit unstable in managing large music collections, especially when playing tracks. For this reason I switched to Virtual DJ with which, unfortunately, I was unable to replicate the method of song cataloging and using the "albumartist" field to classify the name of the singer. VDJ does not have an "albumartist" field but it does have a "singer" field and what I would like to do would be to import from MM the name of the singers (i.e. "albumartist") into the "singer" field. Due to my inexperience I failed in the purpose and therefore I thought of modifying via MP3tag the content of the "artist" field inserting both the main artist and the singer using the encoding " **artist, singer**". I hope I have adequately explained the reason for my request for support and gladly accept further suggestions. Ian ---
**Author:** ![MotleyG](https://community.mp3tag.de/user_avatar/community.mp3tag.de/motleyg/32/440_2.png) [@MotleyG](https://community.mp3tag.de/u/MotleyG)\ **Post date:** [May 18, 2023, 12:08am UTC](https://community.mp3tag.de/t/merging-two-fields-and-blanking-the-second-one/60998/5 "2023-05-18T00:08:29Z")
So the suggestion I made previously doesn’t work for you then? Step 1, update your existing Artist, using the Action (Quick) function of Format Value, the field is `ARTIST` and the format string is `%artist%, %albumartist%` in this case. Step 2, you can simply delete the Albumartist field, if you truly think you don’t need it. But if some software doesn’t support a field like Albumartist, it is usually just ignored. That is why I ask if you truly do not need it. Why delete it if it isn’t a burden, and other players may still benefit from having it. ---
**Author:** ![dec](https://community.mp3tag.de/user_avatar/community.mp3tag.de/dec/32/13699_2.png) [@dec](https://community.mp3tag.de/u/dec)\ **Post date:** [May 18, 2023, 12:52am UTC](https://community.mp3tag.de/t/merging-two-fields-and-blanking-the-second-one/60998/6 "2023-05-18T00:52:33Z")
hi there not sure if it has been covered in other replies: but i see no need whatsoever to null the Albumartist for that reason - just LEAVE the data there for other current or future use ---
**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:** [June 8, 2023, 2:29pm UTC](https://community.mp3tag.de/t/merging-two-fields-and-blanking-the-second-one/60998/7 "2023-06-08T14:29:11Z")
I apologize for the late reply. After reading all the responses I received, I decided not to delete the "albumartist" field (my previous decision to delete it was too radical and without any real benefit). Ian ---
**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\ **Post date:** [July 8, 2023, 2:29pm UTC](https://community.mp3tag.de/t/merging-two-fields-and-blanking-the-second-one/60998/8 "2023-07-08T14:29:41Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.