Remove leading zero from hours & minutes but not seconds

I have been using $trimleft(%_length%,0) for my Length column because I didn't want any leading zeros.

This works, but when dealing with short clips less than 1 minute the zero is still stripped and the length displays as :47 or :55 etc.

How can I strip leading zeros for lengths over 1 minute, but keep one single leading zero for anything under 1 minute?

Try:
$regexp(%_length%,^0(\d:),$1)

1 Like

This works perfectly. Thank you!