Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

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
02-1234 02-1234
05-1234 05-1234
07-1234 07-1234
ACE Emeritus
ACE Emeritus

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

@bryanmason19 Attached would be a simple Regex solution.