Replace special characters different variables

Question

I'm trying to put together firstname + lastname into an email address, and it works, but I need to replace special characters in firstname and lastname or in the finished variable emailad:

function CreateEmailAddress(){

 var ss = SpreadsheetApp.getActiveSpreadsheet(),
     sheet = ss.getActiveSheet(),
     range = sheet.getDataRange(),
     values = range.getValues();
  for (var r=1; r<values.length; r++) {
   var row = values[r],
       firstname = row[0],
       lastname = row[1],
       email = row[2];

       if(email != "nodata" ){

       var emailad = (firstname + "." + lastname + "@superenterprisecompany.com");

      Logger.log(emailad);

    sheet.getRange(1 + r, 3).setValue(emailad);

    }

  }
}

I found this, but do not know how to get it to work with my variables

function convert_accented_characters(str){
    var conversions = new Object();
    conversions['ae'] = 'ä|æ|ǽ';
    conversions['oe'] = 'ö|œ';
    conversions['ue'] = 'ü';
    conversions['Ae'] = 'Ä';
    conversions['Ue'] = 'Ü';
    conversions['Oe'] = 'Ö';
    conversions['A'] = 'À|Á|Â|Ã|Ä|Å|Ǻ|Ā|Ă|Ą|Ǎ';
    conversions['a'] = 'à|á|â|ã|å|ǻ|ā|ă|ą|ǎ|ª';
    conversions['C'] = 'Ç|Ć|Ĉ|Ċ|Č';
    conversions['c'] = 'ç|ć|ĉ|ċ|č';
    conversions['D'] = 'Ð|Ď|Đ';
    conversions['d'] = 'ð|ď|đ';
    conversions['E'] = 'È|É|Ê|Ë|Ē|Ĕ|Ė|Ę|Ě';
    conversions['e'] = 'è|é|ê|ë|ē|ĕ|ė|ę|ě';
    conversions['G'] = 'Ĝ|Ğ|Ġ|Ģ';
    conversions['g'] = 'ĝ|ğ|ġ|ģ';
    conversions['H'] = 'Ĥ|Ħ';
    conversions['h'] = 'ĥ|ħ';
    conversions['I'] = 'Ì|Í|Î|Ï|Ĩ|Ī|Ĭ|Ǐ|Į|İ';
    conversions['i'] = 'ì|í|î|ï|ĩ|ī|ĭ|ǐ|į|ı';
    conversions['J'] = 'Ĵ';
    conversions['j'] = 'ĵ';
    conversions['K'] = 'Ķ';
    conversions['k'] = 'ķ';
    conversions['L'] = 'Ĺ|Ļ|Ľ|Ŀ|Ł';
    conversions['l'] = 'ĺ|ļ|ľ|ŀ|ł';
    conversions['N'] = 'Ñ|Ń|Ņ|Ň';
    conversions['n'] = 'ñ|ń|ņ|ň|ŉ';
    conversions['O'] = 'Ò|Ó|Ô|Õ|Ō|Ŏ|Ǒ|Ő|Ơ|Ø|Ǿ';
    conversions['o'] = 'ò|ó|ô|õ|ō|ŏ|ǒ|ő|ơ|ø|ǿ|º';
    conversions['R'] = 'Ŕ|Ŗ|Ř';
    conversions['r'] = 'ŕ|ŗ|ř';
    conversions['S'] = 'Ś|Ŝ|Ş|Š';
    conversions['s'] = 'ś|ŝ|ş|š|ſ';
    conversions['T'] = 'Ţ|Ť|Ŧ';
    conversions['t'] = 'ţ|ť|ŧ';
    conversions['U'] = 'Ù|Ú|Û|Ũ|Ū|Ŭ|Ů|Ű|Ų|Ư|Ǔ|Ǖ|Ǘ|Ǚ|Ǜ';
    conversions['u'] = 'ù|ú|û|ũ|ū|ŭ|ů|ű|ų|ư|ǔ|ǖ|ǘ|ǚ|ǜ';
    conversions['Y'] = 'Ý|Ÿ|Ŷ';
    conversions['y'] = 'ý|ÿ|ŷ';
    conversions['W'] = 'Ŵ';
    conversions['w'] = 'ŵ';
    conversions['Z'] = 'Ź|Ż|Ž';
    conversions['z'] = 'ź|ż|ž';
    conversions['AE'] = 'Æ|Ǽ';
    conversions['ss'] = 'ß';
    conversions['IJ'] = 'Ĳ';
    conversions['ij'] = 'ĳ';
    conversions['OE'] = 'Œ';
    conversions['f'] = 'ƒ';

    for(var i in conversions){
        var re = new RegExp(conversions[i],"g");
        str = str.replace(re,i);
    }

    return str;
}

note that there are a few inconsistencies in the code above, some accented characters return 2 values... ö returns oe and o... only one will work. I suggest you clean it up to your taste. — Serge insas
– Serge insas, Commented Nov 11, 2014 at 16:44

Serge insas · Accepted Answer · 2014-11-11 15:57:13Z

2

You can use this function you found like this :

function testReplaceAccents() {
  Logger.log(convert_accented_characters("Jean-Noël Esèvéçà"));  
}

result :

enter image description here

so, in your code :

function CreateEmailAddress(){
  var ss = SpreadsheetApp.getActiveSpreadsheet(),
      sheet = ss.getActiveSheet(),
      range = sheet.getDataRange(),
      values = range.getValues();
  for (var r=1; r<values.length; r++) {
    var row = values[r],
        firstname = row[0],
        lastname = row[1],
        email = row[2];
    if(email != "nodata" ){
      var emailad = (firstname + "." + lastname + "@superenterprisecompany.com");
      Logger.log(convert_accented_characters(emailad));
      sheet.getRange(1 + r, 3).setValue(convert_accented_characters(emailad)); 
    }
  }
}

answered Nov 11, 2014 at 15:57

Serge insas

46.9k7 gold badges113 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1928185 · Accepted Answer · 2014-11-11 15:54:14Z

1

Can you try just this one. I think it should work. Please let me know. If not then you have to change convert_accented_characters function.

var emailad = (convert_accented_characters(firstname) + "." + convert_accented_characters(lastname) + "@superenterprisecompany.com")

answered Nov 11, 2014 at 15:54

user1928185

1121 silver badge12 bronze badges

3 Comments

John Smith Over a year ago

It did work : ), but im trying to replace spaces with "-" without luck, you know how to fix that? I tried the following but it did not work: conversions['-'] = '';

user1928185 Over a year ago

Can you give me an example? You mean like Firstname="shah ga". you want it shah-ga

Serge insas Over a year ago

@John : function convert_accented_characters(str){ var conversions = new Object(); conversions['-'] = ' ';// add this

Pang · Accepted Answer · 2014-11-21 01:54:27Z

0

You could try using regular expressions to remove special characters.

For example:

var firstName = "test'name &&^^%%%#s";
var newFirstName=str.replace(/[^a-zA-Z]/g, "");

edited Nov 21, 2014 at 1:54

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Nov 11, 2014 at 15:50

Programmer2.0

541 silver badge10 bronze badges

1 Comment

Serge insas Over a year ago

this will remove all special characters, not replace them with unaccented ones.

Collectives™ on Stack Overflow

Replace special characters different variables

3 Answers 3

Comments

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related