How can I change column values in dynamic table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sakunne
    New Member
    • Jul 2012
    • 2

    How can I change column values in dynamic table

    I got from AJAX query a string like this:
    Code:
    var ansverStr = "[1,\"Bedford Street\",\"Oxford Circus, Green Park or Westminster\",\"15\",\"Regent Street\",1343329406000]\r\n
    [1,\"Bedford Street\",\"Oxford Circus, Green Park or Westminster\",\"13\",\"Golders Green\",1343329883000]\r\n
    [1,\"Bedford Street\",\"Oxford Circus, Green Park or Westminster\",\"176\",\"Tottenham Ct Rd\",1343329612000]"
    ... etc
    Created a dynamic table to expose the data:
    Code:
    var element;
    element = '' + ansverStr.split('\r\n').map(function(line){ return '' + JSON.parse(line).map(function(cell){ return '' + cell + ''; }).join('') + ''; }).join('') + ''; document.getElementById("bStop").innerHTML=element;
    The last field in ansverStr substrings is a time.

    The question: How can I access to those values in this column in dynamic table to convert them into time format
  • Frinavale
    Recognized Expert Expert
    • Oct 2006
    • 9749

    #2
    Like this:
    Code:
    var ansverStr = "[1,\"Bedford Street\",\"Oxford Circus, Green Park or Westminster\",\"15\",\"Regent Street\",1343329406000]\r\n    [1,\"Bedford Street\",\"Oxford Circus, Green Park or Westminster\",\"13\",\"Golders Green\",1343329883000]\r\n [1,\"Bedford Street\",\"Oxford Circus, Green Park or Westminster\",\"176\",\"Tottenham Ct Rd\",1343329612000]";
    
    var lines = ansverStr.split('\r\n');
    
    var elementContent= "";
    
    for(lineIndex = 0; lineIndex<lines.length; lineIndex++) {
        var row = JSON.parse(lines[lineIndex]);
    
        for (i = 0; i < row.length; i++) {
            var rowData = row[i];
            if (i == row.length - 1) {
                var d = new Date(rowData);
                elementContent = elementContent + " " + d;
            } else {
                elementContent = elementContent + " " + rowData;
            }
        }
        
         elementContent = elementContent + "<br /> "
    
    }
    
    document.getElementById("bStop").innerHTML = elementContent;
    -Frinny

    Comment

    • Sakunne
      New Member
      • Jul 2012
      • 2

      #3
      Thanks, the most elegant solution :)

      Comment

      Working...