Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index

The easiest way I can think of is:

Do <Start Menu><All Programs><"Accessories"> and left-click on <Command Prompt>
Change to the directory that includes the "Music" folder using CD command.
Enter this command..
dir Music /S /B >"C:\Users\your-name-here\Desktop\Music-file-list.txt"

It should output a file on your Desktop named Music-file-list.txt

Open Music-file-list.txt with LibreOffice Writer.
Highlight "C:\Users\your-name-here\Music\" and -Find and Replace- With blank Replace line and no "Other Options". Since I don't know where you "Music" folder is, the highlighted text maybe different, but will begin with C: and end with Music\.

This should leave you with something like...


Now -Find and Replace-
Find            \
Replace         ;

If we're lucky and there are no semi-colons in your Song names, we should be safe.

This should leave you with something like...


Insert a blank line on the very first line and type...

Do <File><Save As> Music-file-list-processed.txt
Make sure "Save as type:" is set to "Text (.txt) (*.txt)"
Do not overwrite your original file as a safety precaution.

Close Writer.

Right click on "Music-file-list-processed.txt" from your Desktop.
Open with LibreOffice Calc.
When Text Import screen comes up, make sure "Separator Options" has a check-mark next to Semicolon.

Save as a Calc file.

Now you can play with ways to display data, make corrections data in wrong column and format printing.

Hope this helps

On 4/27/2017 4:13 PM, charles meyer wrote:
Hi Paul,

I'm trying to keep this as simple as possible.

In Windows 7, opening Windows Explorer to my Music folder I can see all the
artists names  and their respective sub-folders.

When I l click on each artist's sub-folder I can then see either their
album name(s) in their sub-folders and then when I open the album
sub-folders I can see all the songs listed under that album (in .mp3 or
.wav format).

Ex, First folder - Abba - last folder - ZZ Top.

Since there are no albums under some of the artists there will just be song

But for those with albums - ex. Sinatra > Album titled Capitol Years (as a
sub-folder under Sinatra)  there wil then be songs listed by tile under the
sub-folder (album).

This info is not stored in a Libre Calc or Excel file not in a Libre Writer
nor MS Word file.

They are just listed in Windows Explorer.

I simply want to print a list of every artist (by name, alphabetically)
with each of their respective albums (by name, if applicable) and then all
of each artist's songs (by name, alphabetically).

Will MusicBrainz Picard < do that or is that
application not designed for what I'm trying to accomplish?

Thanks much.


From: "Paul D. Mirowsky" <>
Date: Tue, 25 Apr 2017 10:46:45 -0400
Subject: Re: [libreoffice-users] Libre Writer or Excel - File Name List -
Two programs to help fill and export metadata.

MusicBrainz Picard <> is a cross-platform
(Linux/Mac OS X/Windows) application written in Python and is the official
MusicBrainz <> tagger.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.