Calculated field: string to float?

a stupid question:
how to convert a string (like a shot name in the form “000100”) to a float or integer value (100) to be used in a calculated field ?

1 Like

Yep. Seems there is no way to do a simple string cast in Calculated Fields. Calculated fields | ShotGrid | Autodesk Knowledge Network

Quite an oversight to be missing the equivalent of Excel’s VALUE function.