# Remove leading zero from hours & minutes but not seconds

**URL:** <https://community.mp3tag.de/t/remove-leading-zero-from-hours-minutes-but-not-seconds/50657>\
**Category:** Support\
**Created:** [November 1, 2020, 2:22am UTC](https://community.mp3tag.de/t/remove-leading-zero-from-hours-minutes-but-not-seconds/50657 "2020-11-01T02:22:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lem](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/l/74df32/32.png) [@Lem](https://community.mp3tag.de/u/Lem)\
**Post date:** [November 1, 2020, 2:22am UTC](https://community.mp3tag.de/t/remove-leading-zero-from-hours-minutes-but-not-seconds/50657/1 "2020-11-01T02:22:00Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\
**Post date:** [November 1, 2020, 8:02am UTC](https://community.mp3tag.de/t/remove-leading-zero-from-hours-minutes-but-not-seconds/50657/2 "2020-11-01T08:02:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Lem](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/l/74df32/32.png) [@Lem](https://community.mp3tag.de/u/Lem)\
**Post date:** [November 1, 2020, 3:56pm UTC](https://community.mp3tag.de/t/remove-leading-zero-from-hours-minutes-but-not-seconds/50657/3 "2020-11-01T15:56:26Z")

</div>

This works perfectly. Thank you!

---

<div class="post-metadata">

**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\
**Post date:** [December 1, 2020, 3:56pm UTC](https://community.mp3tag.de/t/remove-leading-zero-from-hours-minutes-but-not-seconds/50657/4 "2020-12-01T15:56:29Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.