Manipulate Cell contents before/during TableTools "copy to CSV"

robDaniel

Is there a way I can manipulate the contents of a cell as it's being copied by TableTools ?

Some of my Table Cells have HTML   chars before the actual, numeric, contents of the cell, this is causing a problem when we open the CSV in Excel etc, as it's not treated as a numeric cell.

So, what is sent to the browser is "<td><span style='color::red'>    </span>5</td>"
The contents of the CSV, in ascii, appear as : "C2 A0 C2 A0 C2 A0 C2 A0 33"

I'm looking for a way to intercept the C2 A0.. and strip them out, so only the 33 makes it into the CSV.
But maybe there is a better way to achieve what I need to do ?
Thanks.