Hello. I'm trying to extract a composer name ("Tippett") from a title:
Tippett - The Blue Guitar - I. Medium Slow - Slow
I'm using:
$left(%title%,($strchr(%title%,-))
but I'm getting errors. However if I try $strchr(%title%,-) alone, I get a result of 9 (I realize I have to subtract 2 from the result, but first I need to get the result "Tippett -"
$left('Tippett - The Blue Guitar - I. Medium Slow - Slow',$sub($strstr('Tippett - The Blue Guitar - I. Medium Slow - Slow',' -'),1))$left(%TITLE%,$sub($strstr(%TITLE%,' -'),1))