trimming white space...

rbuser

Okay, I've got a TeeChart dbChart which is getting the x-axis text from a db
field. The problem is that the db field usually has a lot of whitespace
trailing the actual text. I assume I can intercept the text somewhere and
perform a Trim, or TrimRight on it before sending it on though to the Chart.
At what point would be the best place to intercept the text and trim it?

--Chris

rbuser

Ahh. I found the GetAxisLabel event. It works.

--Chris

digitalmetaphors

Some databases support trim functions (ie LTRIM or RTRIM) so you could
create calculated fields based on each field you need to handle this for.
You can also wait until the data makes it's way into the pipeline and deal
with trimming in one of the pipeline's event handlers such as OnDataChange
or OnTraversal.
--
Cheers,

Alexander Kramnik
Digital Metaphors