This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello, everyone. I'm a very new Alteryx Designer user and I'm working with my team to help standardize data formats across all of our applications. One of the things that we need to do is to identify name fields that have non-standard characters. For instance, a first name should contain alphabetic characters, perhaps spaces, and maybe an apostrophe. A last name might contain a hyphen. So, with a character set of a-z, A-Z, -, and ', we need to flag fields that do NOT match this.
I came up with this:
I think that this is the right expression, but since this is my first attempt at RegEx, I was hoping for some validation. Do I need to include a space since that is also acceptable?
I believe that the best for this case is for you to feed the workflow with your data and see if the expression works as expected.
But for these default common requirements (names, zip codes, emails, etc), you can find a lot of good and complete expressions out there on the internet. For example, this one seems to cover everything that is necessary to see if a name is valid (but try with your data to see):