What for settings to delete duplicates in iTunes Playlist?

What for settings to delete duplicates in iTunes Playlist?

3

    Mar 17, 2006#1

    in itunes you have the possibility to export the playlist as txt file
    in the format

    Code: Select all

    Name    Artist  Composer        Album   Grouping        Genre   Size    Time    Disc Number     Disc Count      Track Number    Track Count     Year    Date Modified   Date Added      Bit Rate        Sample Rate     Volume Adjustment       Kind    Equalizer       Comments        Play Count      Last Played     My Rating       Location
Fila Brazillia - Soft Music Under Stars Arabic Lounge           Arabic Lounge (CD 1)                    13989888        576                     1               2003    25.02.2006 21:38        19.09.2005 02:20        192     44100           MPEG audio file                 8       15.03.2006 22:38        100     D:\Musik\Arabic Lounge\Arabic Lounge (CD 1)\01 Fila Brazillia - Soft Music Under.mp3
Fila Brazillia - Soft Music Under Stars Arabic Lounge           Arabic Lounge (CD 1)                    13989888        576                     1               2003    25.02.2006 21:38        19.09.2005 02:20        192     44100           MPEG audio file                 8       15.03.2006 22:38        100     D:\Musik\Arabic Lounge\Arabic Lounge (CD 1)\01 Fila Brazillia - Soft Music Under.mp3
Numero Deux     The Dining Rooms                Numero Deux             Acid Jazz       6135017 381                     4               2001    16.09.2005 13:52        19.09.2005 03:07        128     44100           MPEG audio file                 6       15.03.2006 22:43        100     F:\Musik\The Dining Rooms\Numero Deux\04 Numero Deux.mp3
Numero Deux     The Dining Rooms                Numero Deux             Acid Jazz       6135017 381                     4               2001    16.09.2005 13:52        19.09.2005 03:07        128     44100           MPEG audio file                 6       15.03.2006 22:43        100     F:\Musik\The Dining Rooms\Numero Deux\04 Numero Deux.mp3
Prelude Kate Bush               Aerial          Pop     2027332 86                      8               2005    12.02.2006 17:42        02.11.2005 22:34        185     44100           MPEG audio file                 36      15.03.2006 22:44        100     F:\Musik\Kate Bush\Aerial\08 Prelude.mp3
Prelude Kate Bush               Aerial          Pop     2027332 86                      8               2005    12.02.2006 17:42        02.11.2005 22:34        185     44100           MPEG audio file                 36      15.03.2006 22:44        100     F:\Musik\Kate Bush\Aerial\08 Prelude.mp3

    its not good to delete two different files with the same song, but good if you
    have the same file in a list, for example when you merge some playlist in the
    program, but ue screw up the playlist

    i was thinking in the sort preferences, the setting has to be 1 and -1
    but with this setting ue makes some errors
    sorry i install it in a different language and the program don't
    install the english help file and its not possible to change the
    program to english so I'm not sure what the exact name of the function is


    anyway i hope you understand what i mean
    i count the numbers of tags in a line

    Code: Select all

    Name    Artist  Composer        Album   Grouping        Genre   Size    Time    Disc Number     Disc Count      Track Number    Track Count     Year    Date Modified   Date Added      Bit Rate        Sample Rate     Volume Adjustment       Kind    Equalizer       Comments        Play Count      Last Played     My Rating       Location
    they seem to be 25
    so i try the setting 1 and 25
    so it worked a little bit more but for example the lines

    Code: Select all

    Spiritual Indian Bhajans - Chanting Of Gayatri Mantra (108 Times)                                       Other   38016120        2646                                            14.03.2006 21:51        12.03.2006 16:41        114     44100           MPEG audio file                                         F:\Musik\Unknown Artist\Unknown Album\Spiritual Indian Bhajans - Chanting.mp3
Spiritual Indian Bhajans - Chanting Of Gayatri Mantra (108 Times)                                       Other   38016120        2646                                            14.03.2006 21:51        12.03.2006 16:41        114     44100           MPEG audio file                                         F:\Musik\Unknown Artist\Unknown Album\Spiritual Indian Bhajans - Chanting.mp3
    don't work

    i try also 0 and 25 as settings in key 1 (the other key are all 0 0)
    but that doesn't work either, even so 0 0

    any idea what i made wrong and with what setting that will work for
    all songs?

    have a great week end
    adrian
    6,675585
    Grand MasterGrand Master
    6,675585

      Mar 17, 2006#2

      The playlists seem to be CSV files with the tab as separator. A sort with Key 1 - Start Column set to 1 and End Column set to -1 and all other set to 0 should work.

      Maybe you have to use first Format - Trim Trailing Spaces before sort.

      If the fields are not separated by a tab character but with spaces run a regular expression in UltraEdit style with search string "  +" (without " - space space plus) and replace it with ^t. This regular expression will replace more than 1 spaces to a single tab character. Now the sort should work.
      Best regards from an UC/UE/UES for Windows user from Austria
      3

        Re: What for settings to delete duplicates in iTunes Playlis

        Mar 17, 2006#3

        Thanks for your fast answer
        as you mentioned 1 and -1 works for most cases

        but i have some files in it whiteout artist name and this seem to be a
        problem - it seems as itunes then simply cancel the first part and
        that so there are less tabs in a line as in the rest, maybe that is
        the reason which leads ue to the errors


        i can live with it, but maybe you have an idea what i can do

        Code: Select all

        The Merciful One	Zohar		Buddha-Bar (disc 1: Dinner)		Ethnic	7006772	287			6		2000	16.09.2005 18:21	19.09.2005 03:14	193	44100		MPEG audio file						F:\Musik\Zohar\Buddha-Bar (disc 1_ Dinner)\06 The Merciful One.mp3
Jeunesse Senegal			The Rough Guide to the Music of Senegal and Gambia		World	6988187	344			1			16.02.2006 18:39	19.09.2005 02:38	161	44100		MPEG audio file						G:\Musik\Unbekannter Interpret\The Rough Guide to the Music of Senegal\01 Jeunesse Senegal.mp3
Taar Doucey			The Rough Guide to the Music of Senegal and Gambia		World	7001538	342			11			08.02.2006 13:22	19.09.2005 02:38	163	44100		MPEG audio file						G:\Musik\Unbekannter Interpret\The Rough Guide to the Music of Senegal\11 Taar Doucey.mp3
Bhajan - Chanting Of Gayatri Mantra (108 Times) 						38014907	2646						14.03.2006 21:52	12.03.2006 16:40	114	44100		MPEG audio file						F:\Musik\Unknown Artist\Unknown Album\Bhajan - Chanting Of Gayatri Mantra.mp3
        the first has an artist an album the following are incomplete
        the simpler way would be just to insert some nonsense in the file with
        no artist and so it would be work. so there is no need to stick deeper
        in this, but just in case that you have i idea, it would be glad to hear
        it :)

        hmm when i think about it, the only way that would work is to make a
        macro which made the sort, but only uses the last part of the line
        with the path in it.
        but that seems a little to much work, maybe an easier way is just to
        search and replace all but the last word with nothing (as regular expression)
        and so there would be only the file path left - its then not more the itunes
        playlist but maybe as m3u it would work...

        have a great time
        adrian
        6,675585
        Grand MasterGrand Master
        6,675585

          Mar 17, 2006#4

          Well, your idea with the sort based on only the filename with path can be done with a macro. With a regular expression the filename with path is moved to start of the line. Then the sort is executed and last the filename with path is moved back to the end of the line. The sort below does recognize differences in case. Add sort option IgnoreCase if you want to ignore differences in case.

          InsertMode
          ColumnModeOff
          HexOff
          UnixReOff
          Top
          Find RegExp "%^(*^)^t^([A-Z]:[~^t^r^n]+^)$"
          Replace All "^2^t^1"
          SortAsc RemoveDup 1 -1 0 0 0 0 0 0
          Find RegExp "%^([~^t]+^)^t^(*^)$"
          Replace All "^2^t^1"

          If you do not use UltraEdit style regular expressions by default, add UnixReOn or PerlReOn (v12+ of UE) at the end of the macro. UnixReOff modifies the configuration setting for regular expressions.
          Best regards from an UC/UE/UES for Windows user from Austria
          3

            Re: What for settings to delete duplicates in iTunes Playlis

            Mar 18, 2006#5

            wow thanks works like a charm!!!

            you safe me a lot of time, i was still in the beginning of figuring out how to make the regular expression, when you already gave this more
            elegant and sophisticated solution

            well at least now i know that UE-32 v12 can also use pearl expression when you mention to write PerlReOn my unix scripting was very rusty, but i think i have to learn the basics of pearl scripting :)
            so thanks a lot, now i have something to do ;)


            adrian