BOM – Split SIZE column into L, W, H with rounding — how?
Hi everyone,
In our drawing BOM, the SIZE column shows values like 156.000x40.000x33.509 as a single string. I'd like to split this into three separate columns (L, W, H) showing only whole numbers, with standard rounding (anything above .5 rounds up).
Current output in the SIZE column:
156.000x40.000x33.509
800.000x600.000x70.000
156.000x156.000x34.925
Desired output across three columns:
L W H
156 40 34
800 600 70
156 156 35
A few things I'm unsure about:
Is there a way to do this directly in the Creo drawing repeat region table, using column format or symbolic parameters?
Can relations or parameters (e.g. user-defined SIZE_L, SIZE_W, SIZE_H) be used to parse and round the SIZE string, and then called in the BOM table?
Any advice on the best practice for this in Creo Parametric would be appreciated. Thanks!

