AnsweredAssumed Answered

Filter function not allowing "." to filter through

Question asked by markvogan on Aug 31, 2016
Latest reply on Aug 31, 2016 by StephenWonfor

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.

Outcomes