Skip to main content
Question

Gift for the folks who hate accents

  • December 7, 2020
  • 0 replies
  • 54 views

Hi Team,

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
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
Thank you for posting.  I know that accents can mess up Quick Base in many ways but in particular what happens in mobile?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------