Replies

• rf1234 Posts: 2,991Questions: 87Answers: 421

  January 2023

  Use exportOptions.format.body / header / footer like in here for example:

  buttons: [
      {   extend: "csv",
              exportOptions: {
                  format: {
                      body: function ( data, row, column, node ) {
                          //replace ampersands and other special chars
                          data = data.replace(/>/g, '>')
                                     .replace(/&lt;/g, '<')
                                     .replace(/&amp;/g, '&')
                                     .replace(/&quot;/g, '"')
                                     .replace(/&#163;/g, '£')
                                     .replace(/&#39;/g, '\'')
                                     .replace(/&#10;/g, '\n');
                          //replace html tags with one space
                          data = data.replace(/<[^>]*>/g, ' ');
                          //replace multiple spaces and tabs etc with one space
                          return data.replace(/\s\s+/g, ' ');
                      },
                  }
              }
          }
      ]
  
• lenio Posts: 2Questions: 0Answers: 0

  January 2023

  Please, if someone could help me with the regular expression... of this example... because I couldn't solve the problem
• kthorngren Posts: 21,336Questions: 26Answers: 4,951

  January 2023 edited January 2023

  If you use data.replace(/<[^>]*>/g, ' ') it will extract all the text including Área and the options like Sección de Ingeniería. Maybe something like this will work:

  buttons: [
      {   extend: "csv",
              exportOptions: {
                  format: {
                      header: function ( data, row, column, node ) {
                          // Get span text
                          var match = data.match(/<span class="col-title">(.*)<\/span>/);
                          // If found then use that as the data
                          if (match) {
                             data = match[1];
                          }
                          return data;
                      },
                  }
              }
          }
      ]
  

  I did not test this code so it may need some work

  It looks for the specific span text. If its found it will set the returned data to the found text. Otherwise it returns the original data.

  If you still need help please build a simple test case showing an example of what you have so we can provide more specific suggestions.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin