Content Center Input and Filename - Trim trailing and leading zeros from input

[Matthew_Policelli]

We have many content center families with an input for the dimensions of the part - for example, wood where the user inputs the length. The filename is set from the wood board size and the length input by the user.

One issue we have is that there does not seem to be a way to trim trailing or leading zeroes. As a result, for a 10" piece of wood, the inputs 10.0, 010, 10.00, and 10 will result in four different files for the same exact part.

Is there a way to trim leading zeroes from the input so that all of the above inputs would result in the same filename?

More info if it helps:

The File Name is an identifier for the family, with a dash, and the the PARTNUMBER column. Here is the properties page for the PARTNUMBER column:

[CGBenner]

@Matthew_Policelli 

Hi, Matthew.  After some quick testing, I don't see any way to set this so that it can trim the zeroes as you suggest.  I've asked internally if there is any way to limit what acceptable formats can be entered here for length, but it may be a training issue for your users.  I'm hoping to get some feedback, and I will follow up if I hear anything.

Meanwhile, I open the floor to our community experts to tell me that I'm way off on this one!  🙂  Maybe there is a custom solution out there, or an obvious one that I've missed?

[CGBenner]

@Matthew_Policelli 

I've been reminded of THIS thread from a while back relating a very similar question, and offering  couple of ways to solve this.  Maybe something in here can be of help to you?