Forum Discussion

GiuseppeMacri's avatar
GiuseppeMacri
Qrew Captain
5 years ago

Gift for the folks who hate accents

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
------------------------------
  • 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
    ------------------------------
    • GiuseppeMacri's avatar
      GiuseppeMacri
      Qrew Captain
      On Mobile, its really hit or miss if the accents appear as intended of show up as <?> symbols. Also for the above formula to work, a user needs to add $cp at the end.

      ------------------------------
      GMacri
      ------------------------------