Afternoon Team,
hope your well.
I need some assistance.
I have the a column called "Name". I would like to identify any name where the characters of the name does not meet the criteria below ;
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ À
Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß à
á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ
Example
Name | Outcome |
Alteryx | Okay |
株式会社三井住友銀行 | Fail |
Looking forward to your response
Regards
Masond3
@IraWatt Thats super, if i have other name fields i want to check, lets say name is broken out into "first name" & "last name" how would that be achieved?
@IraWatt apologizes - i meant to say is it possible to have two outcomes, one for the first name, one for the last name ?