//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(); }