It's the rest I'm struggling with.
Simple date and time formatting only (results in: YYMMDD hh'h'mm'ss, e.g. 091027 23h20'35):
$substr(%datetime%,23,24)$replace($substr(%datetime%,5,7),Jan,01,Feb,02,Mar,03,Apr,04,May,05,Jun,06,Jul,07,Aug,08,Sep,09,Oct,10,Nov,11,Dec,12)$substr(%datetime%,9,10) $substr(%datetime%,12,13)'h'$substr(%datetime%,15,16)''$substr(%datetime%,18,19)
More complete syntax:
$if(%isplaying%,$if(%ispaused%,
$substr(%datetime%,23,24)$replace($substr(%datetime%,5,7),Jan,01,Feb,02,Mar,03,Apr,04,May,05,Jun,06,Jul,07,Aug,08,Sep,09,Oct,10,Nov,11,Dec,12)$substr(%datetime%,9,10) $substr(%datetime%,12,13)'h'$substr(%datetime%,15,16)''$substr(%datetime%,18,19)' '
[%artist%' ']$if(%title%,['['$if2(%album%,<no album>)[ %date%]'] '][#[%disc%/]$num(%tracknumber%,2) ]%title%,%_filename%) '[paused ]'
'('%codec% '('$info(encoding)')' %samplerate% Hz %bitrate% kBit/s $if2($info(mp3_stereo_mode),%channels%)')'
[ %path%][ $meta(URL)]
[ '[Last modified: '$replace($substr(%last_modified%,3,16),-,,:,h)']']
[ '[Added: '$replace($substr(%added%,3,16),-,,:,h)']']
[ '[Length: '%length%']']
$char(10),
$substr(%datetime%,23,24)$replace($substr(%datetime%,5,7),Jan,01,Feb,02,Mar,03,Apr,04,May,05,Jun,06,Jul,07,Aug,08,Sep,09,Oct,10,Nov,11,Dec,12)$substr(%datetime%,9,10) $substr(%datetime%,12,13)'h'$substr(%datetime%,15,16)''$substr(%datetime%,18,19)' '
[%artist%' ']$if(%title%,['['$if2(%album%,<no album>)[ %date%]'] '][#[%disc%/]$num(%tracknumber%,2) ]%title%,%_filename%) '[>playing]'
'('%codec% '('$info(encoding)')' %samplerate% Hz %bitrate% kBit/s $if2($info(mp3_stereo_mode),%channels%)')'
[ %path%][ $meta(URL)]
[ '[Last modified: '$replace($substr(%last_modified%,3,16),-,,:,h)']']
[ '[Added: '$replace($substr(%added%,3,16),-,,:,h)']']
[ '[Length: '%length%']']
$char(10)),
$substr(%datetime%,23,24)$replace($substr(%datetime%,5,7),Jan,01,Feb,02,Mar,03,Apr,04,May,05,Jun,06,Jul,07,Aug,08,Sep,09,Oct,10,Nov,11,Dec,12)$substr(%datetime%,9,10) $substr(%datetime%,12,13)'h'$substr(%datetime%,15,16)''$substr(%datetime%,18,19)' '
stopped$char(10)$char(10))
Results in:
091028 09h29'22 Jason Crane [The Jazz Session 2009] #100 The Jazz Session #100: Bernie Flanders, My Grandfather [>playing] (MP3 (lossy) 44100 Hz 128 kBit/s stereo) D:\music\The Jazz Session\tjs-2009-10-23.mp3 The Jazz Session #100- Bernie Flanders, My Grandfather.mp3 [Last modified: 091023 19h27] [Added: 091023 20h56] [Length: 42:10]
091028 09h54'50 Jason Crane [The Jazz Session 2009] #100 The Jazz Session #100: Bernie Flanders, My Grandfather [paused ] (MP3 (lossy) 44100 Hz 128 kBit/s stereo) D:\music\The Jazz Session\tjs-2009-10-23.mp3 The Jazz Session #100- Bernie Flanders, My Grandfather.mp3 [Last modified: 091023 19h27] [Added: 091023 20h56] [Length: 42:10]
091028 10h14'22 Jason Crane [The Jazz Session 2009] #100 The Jazz Session #100: Bernie Flanders, My Grandfather [>playing] (MP3 (lossy) 44100 Hz 128 kBit/s stereo) D:\music\The Jazz Session\tjs-2009-10-23.mp3 The Jazz Session #100- Bernie Flanders, My Grandfather.mp3 [Last modified: 091023 19h27] [Added: 091023 20h56] [Length: 42:10]
091028 10h33'53 stopped
and can be imported in Excel (separator = three spaces).
[!--sizeo:1--][span style=\"font-size:8pt;line-height:100%\"][!--/sizeo--]Moderation: replaced code with codebox to prevent wrecking the page layout[/size]