"Undoing" AutoCapitilise ? Options

[swayzak]

hi

After a few too many glasses of wine ( ) I stupidly Capitilised my entire 160GB music collection - thereby correcting some annoying problems with letters, but creating annoying problems

e.g all "DJ"s became Dj, MCs to Mc, vol II to vol Ii, CD1 to Cd1 etc.

Is there anyway I can correct this relatively painlessly ?


PS. FB2K is far to powerful a tool to be toyed with on alcohol ...

[Frank Bicking]

You don't actually need any of those apostrophes:

CODE

[$trim($replace($meta(title) , ep , EP , Ep , EP , cd , CD , Cd , CD , dj , DJ , Dj , DJ , Ii , II , Iii , III , Iv , IV , Vi , VI , Vii , VII , Viii , VIII , Ix , IX ))]

[Lyx]

Same reply as yesterday. If whitespace is important, i prefer to explicitely quote it, regardless of it not being "required".

If you can give me a hint how i can set a monospace font for all formattingstring inputareas in fb2k, i may drop that habbit :)

This post has been edited by Lyx: Nov 8 2008, 02:49

[Lyx]

P.S.:

Doing such replacement operations for MC can result in false matches, because there IS an abbreviation which is capitalized as "Mc". You dont want "Mc Donalds" turned into "MC Donalds", right? For that case, better do a manual DB search and then apply a fix to handselected set of tracks.

[odyssey]

P.S.:

Doing such replacement operations for MC can result in false matches, because there IS an abbreviation which is capitalized as "Mc". You dont want "Mc Donalds" turned into "MC Donalds", right? For that case, better do a manual DB search and then apply a fix to handselected set of tracks.

I took that into account by replacing any Mca > McA, Mcb > McB etc. Ugly, but very good!

For anyone interested, this is what I do:

CODE

$replace($caps2(%title%),'[','(',']',')',N''',n''','''N,'''n,'''N''','''n''', ?,?, !,!,  , ,Inch,",Th ,th ,Feat.,feat.,Feat ,feat. ,Featuring ,feat. ,Ft ,feat. ,Ft. ,feat. ,Versus ,vs. ,Vs , vs.,Vs.,vs.,Pres.,pres.,Pres ,pres. ,Presents ,pres. ,Present ,pres. ,Meets ,meets ,Van ,van ,Von ,von ,Mc ,MC ,Dj,DJ,A ,a ,An ,an ,The ,the ,And ,and ,But ,but ,Or ,or ,Nor ,nor ,At ,at ,By ,by ,For ,for ,From ,from ,In ,in ,Into ,into ,Of ,of ,Off ,off ,On ,on ,Onto ,onto ,Out ,out ,Over ,over ,To ,to ,Up ,up ,With ,with ,Mca,McA,Mcb,McB,Mcc,McC,Mcd,McD,Mce,McE,Mcf,McF,Mcg,McG,Mch,McH,Mci,McI,Mcj,McJ,Mck,McK,Mcl,McL,Mcm
,McM,Mcn,McN,Mco,McO,Mcp,McP,Mcq,McQ,Mcr,McR,Mcs,McS,Mct,McT,Mcu,McU,Mcv,McV,Mcw,McW,Mcx,McX,Mcy,McY
,
Mcz,McZ)

It also does it best, lowercasing all words that shouldn't be uppercased