When including numeric values in the expression to build up a character string, it’s common to use the Trim (removes leading and trailing spaces) and Str (converts numerics to characters) functions together, such as:
Trim(Str(MyValue))
The equivalent when programming in Excel is the Cstr() function, so why not go ahead and build yourself a custom function in Monarch to do the same thing?
{ 1 comment… read it below or add one }
Now THAT is a great idea!
If you have colleagues who would also use it make it available in a central library model of custom functions and save everyone some time and effort. There is no point in everyone inventing their own wheel.