User Tools

Site Tools


email-import-header
 //email-import-header
 function formatAddresses() {  
   var sheet = SpreadsheetApp.getActiveSheet();
   var data = sheet.getDataRange().getValues();
   var newData = [];  
 
   for (var i=0, len=data.length; i<len; i++) {
     // inner loop applies to sub-arrays
     for (var j=0, len2=data[i].length; j<len2; j++) {
        var str=data[0][j];
        var str1=str.replace('>','');
        var str2=str1.split('<');
         newData.push(str2);
     }
 }
 
   sheet.clearContents();
   sheet.getRange(1, 1, newData.length, newData[0].length).setValues(newData);
  
 }
 function onOpen() {
   var ui = SpreadsheetApp.getUi();
   // Or DocumentApp or FormApp.
   ui.createMenu('Cleanup contacts from email header')
       .addItem('Format and convert from columns to rows!', 'formatAddresses')
       .addToUi();  
 }
email-import-header.txt · Last modified: 2017/03/08 03:15 by pete