community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Formula to look filter numbers with format differences

Hi All,

 

I am looking to write a filter that will help me separate my data field into two streams. I have a large list of account numbers that have differing formats. In our current system, all account number start with a 6 (ex. 6XXXXX). The issue is that some of the numbers are still in the old format which give each account a two digit category assignment (ex 02-XXXX or 05-XXXX). I need help writing a formula to separate the accounts that start with a 6 and the ones that start with the two digit code. Any advice would be greatly appreciated.

 

Here is an example of what I am trying to achieve:

 

Account #Stream 1Stream 2
612345612345 
623456623456 
02-1234 02-1234
634567634568 
05-1234 05-1234
07-1234 07-1234
645789645790 
Highlighted
ACE Emeritus
ACE Emeritus

Create a filter that with this formula.   Left([Account #],1) = '6'. 

@bryanmason19 Attached would be a simple Regex solution.

Labels