Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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