1 Reply Latest reply on Aug 31, 2016 1:28 PM by StephenWonfor

    Filter function not allowing "." to filter through

    markvogan

      I wrote/copied the following function:

      TrimAll(

         Filter(

            Substitute( Text ; [ "ÿ" ; "y" ] ; [ "ü" ; "u" ] ; [ "ö" ; "o" ] ; [ "ï" ; "i" ] ; [ "ë" ; "e" ] ; [ "ä" ; "a" ] ; [ "Ÿ" ; "Y" ] ; [ "Ü" ; "U" ] ; [ "Ö" ; "O" ] ; [ "Ï" ; "I" ] ; [ "Ë" ; "E" ] ; [ "Ä" ; "A" ] ; [ "õ" ; "o" ] ; [ "ñ" ; "n" ] ; [ "ã" ; "a" ] ; [ "Õ" ; "O" ] ; [ "Ñ" ; "N" ] ; [ "Ã" ; "A" ] ; [ "û" ; "u" ] ; [ "ô" ; "o" ] ; [ "î" ; "i" ] ; [ "ê" ; "e" ] ; [ "â" ; "a" ] ; [ "Û" ; "U" ] ; [ "Ô" ; "O" ] ; [ "Î" ; "I" ] ; [ "Ê" ; "E" ] ; [ "Â" ; "A" ] ; [ "ý" ; "y" ] ; [ "ú" ; "u" ] ; [ "ó" ; "o" ] ; [ "í" ; "i" ] ; [ "é" ; "e" ] ; [ "á" ; "a" ] ; [ "Ý" ; "Y" ] ; [ "Ú" ; "U" ] ; [ "Ó" ; "O" ] ; [ "Í" ; "I" ] ; [ "É" ; "E" ] ; [ "Á" ; "A" ] ; [ "ù" ; "u" ] ; [ "ò" ; "o" ] ; [ "ì" ; "i" ] ; [ "è" ; "e" ] ; [ "à" ; "a" ] ; [ "Ù" ; "U" ] ; [ "Ò" ; "O" ] ; [ "Ì" ; "I" ] ; [ "È" ; "E" ] ; [ "À" ; "A" ] ; [ "." ; " " ] ; [ "-" ; " " ] ; [ "'" ; " " ] ; [ "_" ; " " ] ; [ "," ; " " ]  ) ; //end substitute command

       

      Case(

      FilterType = "a" ; "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";

      FilterType = "an" ; "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";

      FilterType = "ans"; " 0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";

      FilterType = "n"; "0123456789";

      FilterType = "date"; "/-0123456789";

      FilterType = "e" ; ".@-0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";

      FilterType = "" ; " 0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" ;

      ""

      ) &

      AddlChars ) ; //end filter command

      0 ; 2  ) //TrimAll parameters

       

      --------------------------

      When I run this function where

      Text = "me@myemailaddress.com" ;

      FilterType = "e" ;

      AddlChars = ""

       

      The Output is "me@myemailaddresscom" where the "." is missing. I cannot get the "." to show up.