Tag Archives: NumberToString
StringToNumber allows us to convert a value, stored as text, into a number in TM1 Turbo Integrator processes. From there it can be used mathematically.
NumberToString Function for use in Turbo Integrator processes in TM1 and Planning Analytics to convert numbers to text (or strings). From here you can use it with other strings or output to a text file.
When outputting data from TM1 usually we can get away with comma separated values format. Which is standard functionality from a Turbo Integrator process [See ASCIIOutput, TextOutput functions]. Every now and then we need to interface with a ERP system which requires Fixes Width Fields. This presents a few problems, not insurmountable but still not expressly easy either. The tips below will make things easier for you. ASCII Quote Character Options To start your extract process … Continue Reading