Gift for the folks who hate accents
In the spirit of giving, i'm sharing this long formula text field that removes and replaces several accent characters. Really useful for mobile.
var text aa=SearchAndReplace([Text Field],"À", "A");
var text ab=SearchAndReplace($aa,"Á", "A");
var text ac=SearchAndReplace($ab,"Â", "A");
var text ad=SearchAndReplace($ac,"Ã", "A");
var text ae=SearchAndReplace($ad,"Ä", "A");
var text af=SearchAndReplace($ae,"Å", "A");
var text ag=SearchAndReplace($af,"Æ", "AE");
var text ah=SearchAndReplace($ag,"Ç", "C");
var text ai=SearchAndReplace($ah,"È", "E");
var text aj=SearchAndReplace($ai,"É", "E");
var text ak=SearchAndReplace($aj,"Ê", "E");
var text al=SearchAndReplace($ak,"Ë", "E");
var text am=SearchAndReplace($al,"Ì", "I");
var text an=SearchAndReplace($am,"Í", "I");
var text ao=SearchAndReplace($an,"Î", "I");
var text ap=SearchAndReplace($ao,"Ï", "I");
var text aq=SearchAndReplace($ap,"Ð", "ETH");
var text ar=SearchAndReplace($aq,"Ñ", "N");
var text as=SearchAndReplace($ar,"Ò", "O");
var text at=SearchAndReplace($as,"Ó", "O");
var text au=SearchAndReplace($at,"Ô", "O");
var text av=SearchAndReplace($au,"Õ", "O");
var text aw=SearchAndReplace($av,"Ö", "O");
var text ax=SearchAndReplace($aw,"Ø", "O");
var text ay=SearchAndReplace($ax,"Ù", "U");
var text az=SearchAndReplace($ay,"Ú", "U");
var text ba=SearchAndReplace($az,"Û", "U");
var text bb=SearchAndReplace($ba,"Ü", "U");
var text bc=SearchAndReplace($bb,"Ý", "Y");
var text bd=SearchAndReplace($bc,"Þ", "THORN");
var text be=SearchAndReplace($bd,"ß", "s");
var text bf=SearchAndReplace($be,"à", "a");
var text bg=SearchAndReplace($bf,"á", "a");
var text bh=SearchAndReplace($bg,"â", "a");
var text bi=SearchAndReplace($bh,"ã", "a");
var text bj=SearchAndReplace($bi,"ä", "a");
var text bk=SearchAndReplace($bj,"å", "a");
var text bl=SearchAndReplace($bk,"æ", "ae");
var text bm=SearchAndReplace($bl,"ç", "c");
var text bn=SearchAndReplace($bm,"è", "e");
var text bo=SearchAndReplace($bn,"é", "e");
var text bp=SearchAndReplace($bo,"ê", "e");
var text bq=SearchAndReplace($bp,"ë", "e");
var text br=SearchAndReplace($bq,"ì", "i");
var text bs=SearchAndReplace($br,"í", "i");
var text bt=SearchAndReplace($bs,"î", "i");
var text bu=SearchAndReplace($bt,"ï", "i");
var text bv=SearchAndReplace($bu,"ð", "o");
var text bw=SearchAndReplace($bv,"ñ", "n");
var text bx=SearchAndReplace($bw,"ò", "o");
var text by=SearchAndReplace($bx,"ó", "o");
var text bz=SearchAndReplace($by,"ô", "o");
var text ca=SearchAndReplace($bz,"õ", "o");
var text cb=SearchAndReplace($ca,"ö", "o");
var text cc=SearchAndReplace($cb,"ø", "o");
var text cd=SearchAndReplace($cc,"ù", "u");
var text ce=SearchAndReplace($cd,"ú", "u");
var text cf=SearchAndReplace($ce,"û", "u");
var text cg=SearchAndReplace($cf,"ü", "u");
var text ch=SearchAndReplace($cg,"ý", "y");
var text ci=SearchAndReplace($ch,"þ", "thorn");
var text cj=SearchAndReplace($ci,"ÿ", "y");
var text ck=SearchAndReplace($cj,"Œ", "oe");
var text cl=SearchAndReplace($ck,"œ", "oe");
var text cm=SearchAndReplace($cl,"Š", "s");
var text cn=SearchAndReplace($cm,"š", "s");
var text co=SearchAndReplace($cn,"Ÿ", "y");
var text cp=SearchAndReplace($co,"ƒ", "f");
-G
------------------------------
GMacri
------------------------------