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...
Sinatra\CapitolYears\MyWay
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...
Sinatra;CapitolYears;MyWay
Insert a blank line on the very first line and type...
"Artist";"Album";"Song"
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
Paul
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
titles,
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 <http://picard.musicbrainz.org do that or is that
application not designed for what I'm trying to accomplish?
Thanks much.
Charles.
From: "Paul D. Mirowsky" <[email protected]>
To: [email protected]
Date: Tue, 25 Apr 2017 10:46:45 -0400
Subject: Re: [libreoffice-users] Libre Writer or Excel - File Name List -
Pritning
Two programs to help fill and export metadata.
MusicBrainz Picard <http://picard.musicbrainz.org> is a cross-platform
(Linux/Mac OS X/Windows) application written in Python and is the official
MusicBrainz <http://musicbrainz.org> tagger.
https://picard.musicbrainz.org/
<snip>
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
