How can I filtrated from the total list of all similar names (artists and titles)?
For example:
From all
Track -Artist -Title
26 -Fat Domino -Jambalaya
12 -Gordon Langford and his Orch -Jambalaya
11 -Hank Williams -Jambalaya
11 -Hank Williams -Jambalaya
8 -Hanson -Mmmbop
17 -Harold Faltermeyer -Axel F
11 -Harry Belafonte -Banana Boat
11 -Harry Belafonte -Banana Boat (Day-O)
8 -Harry Nilsson -Without You
25 -Heintje -Ich Bau Dir Ein Schloss
15 -Henk Westbroek -Zelfs Je Naam Is Mooi
23 -Herb Alpert -This Guy's In Love With You
15 -Herman Emmink -Tulpen Uit Amsterdam
6 -Indeep -Last Night The DJ Saved My Live
15 -Inner Circle -Sweat (A La La La Long)
17 -Inxs- Never Tear Us Apart
13 -Inxs -Suicide Blonde
8 -Irene Cara -Fame
8 -Irene Cara -Fame
21 -Ivy League -Tossing And Turning
2 -Jacksons -Blame It On The Boogie
15 -Jacksons -Shake Your Body (Down To The Ground)
7 -Jacky Wilson -Reet Petite
7 -Jacky Wilson -Reet Petite
To
26 -Fat Domino -Jambalaya
12 -Gordon Langford and his Orch -Jambalaya
11 -Hank Williams -Jambalaya
11 -Hank Williams -Jambalaya
11 -Harry Belafonte -Banana Boat
11 -Harry Belafonte -Banana Boat (Day-O)
17 -Inxs -Never Tear Us Apart
13 -Inxs -Suicide Blonde
8 -Irene Cara -Fame
8 -Irene Cara -Fame
2 -Jacksons- Blame It On The Boogie
15 -Jacksons -Shake Your Body (Down To The Ground)
7 -Jacky Wilson -Reet Petite
7 -Jacky Wilson -Reet Petite
Hi i_edgars, my first impulse was to suggest, that you have to use a simple text editor to remove unwanted lines from the list. But there might be the possibility, that the current problem can be eliminated a step before the process, which create your first list.
Some questions:
Do you want to filter the first list and what is the rule?
Who respectively what application did create the first list of 24 list items and how was it realized?
Why does the second list contain only 14 list items?
What sense is combined with the bolded words?
Why there are lines in the second list which have a different structure than the related line in the first list? Example:
(1) 2 -Jacksons -Blame It On The Boogie
(2) 2 -Jacksons- Blame It On The Boogie
Note the position of the second hyphen.
The first list are all songs (tegs).
I are marked bold all the names (artists, titles) that are repeated several times.
I want filtrated (in one step) from the first list so as to be visible only to the artists and the titles are repeated. It would not be visible to others.
The second list is the result of which I'd like to see first list after filtering.
There may be a better show than screen?
And sorry for my English.
Some names (artists, titles) are repeated several times. The first list (all songs) Tags Export txt
I want filtrated (in one step) from the first list so as to be visible only to the artists and the titles are repeated. It would not be visible to others.
The second list is the result of which I'd like to see first list after filtering. The second list (after filtering)
But, how can I filtrated from the total list of all similar (repeated) names (artists and titles)?
Which command I entered the field of filtration?
P.s. This list is a very small part of my collection. The collection contains more than 2 000 songs. Manually checked and look all similar artist and all similar songs it is practically impossible.
Do you want to filter the Mp3tag list view on screen?
Or do you want to create a filtered export output file?
Mp3tag's filter mode [F3] is described in the manual under section "Filtering files and tags (Searching)" and there are examples how to use, and see the related topic here in the forum's support area.
Filtering the data for an export can be done in different ways.
For example, the list view can be filtered and sorted, and then run a simple export script on that filtered view.
Or use an filtered or unfiltered amount of tracks and do the filtering within an sophisticated export script by using $if() conditions and other scripting functions to decide and control what you want to put out.
In general the "one step" approach in a confusing environment will not be the best way to solve the problem. Try to break up the problem into smaller steps.
The filter expression ... TITLE HAS "Jambalaya"
... will set the Mp3tag list view to display all files, which TITLE tag field's content contains the string "Jambalaya".
The filter expression ... ARTIST IS "Harry Belafonte"
... will set the Mp3tag list view to display all files, which ARTIST tag field's content is the string "Harry Belafonte".
If you want to see both results in one list view, then you have to combine both filter expressions by an OR operator ("show me this or that at once"). (TITLE HAS "Jambalaya") OR (ARTIST IS "Harry Belafonte")
If you want to see only "Hank William's Jambalaya" tracks in the list view, then you have to combine filter expressions by an AND operator ("show me this only together with that"). (TITLE HAS "Jambalaya") AND (ARTIST IS "Hank Williams")
O no! It's not really feasible if the collection has thousands of songs!
I want to find all the duplicate names (artists and titles) in filtration.
Besides, despite what they are! To finally delete the part of the found duplicate songs and keeping only one song (from which duplicates). As well as to view all the songs (titles) that meet various performers (artists).
This is something similar activities in exel:
[1.] Sort by artist, then by title > Exact (title A: title B) if is True = show A and B, if is False = not show A and B,
or [2.] Sort by title > Exact (title A: title B) if is True = show A and B too, if is False = not show A and B.
This is what I want in exel can not do a single step.
At least one step may be filtrated as Exel's: 1. or 2.?
Mp3tag has no automatic duplicate finder.
Try to solve the task with MS Excel or some other spreadsheet or even better database application.
Look around in the music tagging area, there might exist some application, which can search for duplicate tag content, some application can find also music related duplicate or similar binary music data.
Good luck!