Expression syntax to zero fill a string to 6 chars

I have an expression tag that combines two tags, a string and integer tag. I need to make sure the Integer is always 6 numbers (fill with zeros if less than 999999, I.E… 000101), before I get crazy with this, is there a semi simple way to do this with the expression language or do I need to add some scripting to do it? Thanks!

numberFormat with "%06d" for the pattern maybe?

1 Like

stringFormat

2 Likes

Thanks, I just used try(substring({[.]Prefix},1,3)+numberFormat(tag({Number}),"000000"), '')

I was definitely overthinking that one, thank you both!