Re: [libreoffice-users] Libre Writer or Excel - File Name List - Pritning

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" <p_mirowsky@bentaxna.com>
> To: users@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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