Answers

• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  February 2022 Answer ✓

  One option is to use columns.render with a regex expression to remove the " from the string. Maybe something like this str.replace(/^"|"$/g, '').

  Kevin
• lschneiderman Posts: 17Questions: 5Answers: 0

  February 2022

  @kthorngren How would I stringify the data?
• lschneiderman Posts: 17Questions: 5Answers: 0

  February 2022

  @kthorngren I got some of it to work:

  columns: [
  { title: "Venue", data: "venue", render: function ( data, type, row, meta ) {
  return data.replace(/"/g, "");
  } },
  { title: "Address", data: "address" },
  { title: "Neighborhood", data: "neighborhood" },
  { title: "Phone", data: "phone"},
  { title: "Times", data: "times", render: function ( data, type, row, meta ) {
  return data.replace(/"/g, "");
  }

          },
          { title: "Menu", data: "menu" },
          { title: "Notes", data: "notes" }
          ]
  

  But when I try to apply the same code to the menu or notes data, I get the message "data.replace is not a function" in my console log. Any insight into why data.replace works with two types of data, but not others?
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  February 2022

  Looks like you might have some non-string data:

  Maybe a boolean value?

  

  Maybe null instead of blank strings in Notes?

  

  You might need to use if statements to do some type check and handle the data appropriately.

  You can use columnDef for the columns.render function since it will be the same for multiple columns. Something like this:

    "columnDefs": [ {
        "targets": [ 0, 2 ],  // List all the columns to apply this function
        "render": function ( data, type, row, meta ) {
           if ( data === null ) {. // Do some type checking
             return "";
           }
           return data.replace(/"/g, "");
          } 
      } ]
  

  The above may have syntax errors as I didn't test it

  Kevin
• lschneiderman Posts: 17Questions: 5Answers: 0

  February 2022

  Thanks, Kevin!