Archive for February, 2008
Posted in February 18th, 2008
When modeling a report that includes grand totals, always take an extra minute or two to build a summary that totals all of your extracted values to ensure that you’ve modeled the data as accurately as you think you have. You’ll be happy to see that the totals balance to the report.
But you’ll be thrilled […]
continue reading.....
Posted in February 17th, 2008
The agenda for the 2008 Datawatch User Conference to be held in Phoenix Arizona was recently published, and I’m very pleased that I’ve been selected to once again provide a presentation to the group.
The conference is a fantastic opportunity to learn about Monarch and the other Datawatch products with which you may not have had […]
continue reading.....
Posted in February 16th, 2008
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 […]
continue reading.....