Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Formula to check if Name field holds valid Characters

Masond3
8 - Asteroid

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 

NameOutcome
AlteryxOkay
株式会社三井住友銀行Fail 

 

Looking forward to your response 

Regards
Masond3

6 REPLIES 6
IraWatt
17 - Castor
17 - Castor

Hey @Masond3,

Here is one way of doing this:

IraWatt_0-1654612495521.png

Any questions or issues please ask :)
HTH!
Ira

 

Masond3
8 - Asteroid

@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
17 - Castor
17 - Castor

I think this achieves this, let me know if not:

IraWatt_0-1654613534398.png

Also noticed I needed to add \n to the original solution:

IraWatt_1-1654613595328.png

 

 

Masond3
8 - Asteroid

@IraWatt  apologizes - i meant to say is it possible to have two outcomes, one for the first name, one for the last name ? 

IraWatt
17 - Castor
17 - Castor

😄 my solution may be getting a bit long but I think this works for any number of columns:

IraWatt_0-1654614457344.png

 

Matt_D
9 - Comet

Unicode characters REGEX might be easier?

 

Regex_Replace([Name],"[[:unicode:]]",'') = [Name]

 

 

Labels