3.0 beta 2

How do I replace the values partially in a cell?

The grid data I get goes like this:

var myCells = [
["MSFT","Microsoft Corporation", "#1329707339#02/19/12 20:08 PM"],
["ORCL", "Oracle Corporation", "#1329449106#02/16/12 20:25 PM"]

I need to fix the data in the date column by getting rid of the digits between the hashes.

"#1329449106#02/16/12 20:25 PM" should be just "02/16/12 20:25 PM"

I can't change it in the incoming data, so I need to correct it as the grid is displayed. Any suggestions? Is there a replace function that I can use? I tried the setCellFormat, but I'm probably not doing it correctly. Please help.
May 4,
Nevermind ... found the response in the following thread:


var myDataArray = [...];
function myDataFunction(c, r){return myDataArray[r][c].replace(..., ...)};

I feel like I'm on a treasure hunt for every solution in this forum. Nothing is easy to find.
May 7,

This topic is archived.

See also:

Back to support forum


Version 2

Looking for AW 2.6 ?
The old site is here.