Small Caps Tags

[aktor]

This formula should make a text small caps. Can someone correct it to work in Music bee.
$Upper("LEFT("<Title>",1"))+LOWER(SUBSTRING(<Title>,2,LEN(<Title>)))

[hiccup]

This formula should make a text small caps. Can someone correct it to work in Music bee.
$Upper("LEFT("<Title>",1"))+LOWER(SUBSTRING(<Title>,2,LEN(<Title>)))

That's quite a mess, and it contains many syntax mistakes.
You would better look at the functions $TitleCase and $SentenceCase.

See here for explanations and examples: MusicBee functions for virtual tags cheatsheet

[karbock]

That's quite a mess, and it contains many syntax mistakes.

Indeed. Detailed remarks about @aktor's formula:

• Each function name must start with $.
• The double quotes are misplaced. They must surround literal text only.
• Function $Substring does not exist. Use $CutLeft or $CutRight instead.
• No string concatenation symbol (+) is needed.

Corrected formula:

$Upper($Left(<Title>,1))$Lower($CutLeft(<Title>,1))

But @hiccup's suggestions ($TitleCase and $SentenceCase) are better, provided you have installed plugin "Additional Tagging & Reporting Tools" first.

[aktor]

I must insist that it doesn t work. I was probably unclear. I want a title in all caps but first letter in a word is bigger then the rest. It is usually called  small caps. Click this link https://cdncms.fonts.net/images/4c05fba0ac3fc11/C.Small-caps.gif for reference.
Thanks

[karbock]

Then, what you need is a custom font with a 'small caps' feature.
A few (free) ones that I know:

• Alegreya SC
• Alegreya Sans SC
• Vollkorn SC
• Ysabeau SC

They all include the three European scripts (Latin, Cyrillic and Greek).

But be aware that custom fonts used in virtual tags are taken into account in the main panel,
not in the thumbnail browser or the column browser.

[aktor]

Thank you. It is very useful info.

[hiccup]

This formula should make a text small caps. Can someone correct it to work in Music bee.
$Upper("LEFT("<Title>",1"))+LOWER(SUBSTRING(<Title>,2,LEN(<Title>)))

I am curious:
Any chance that a LLM tool such as ChatGPT provided you with this solution?
I just did some testing to see how good ChatGPT is in providing formulas for virtual tags for MusicBee, and it is really bad at it.
For one thing, it keeps inventing and suggesting functions that are not existent for MusicBee. (similar to your 'SUBSTRING')

[aktor]

here: https://stackoverflow.com/questions/15290754/sql-capitalize-first-letter-only
Do you use ChatGPT as a search tool?