Formula to look filter numbers with format differences

[bryanmason19]

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 1	Stream 2
612345	612345
623456	623456
02-1234		02-1234
634567	634568
05-1234		05-1234
07-1234		07-1234
645789	645790

[tsturge · Accepted solution]

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

[patrick_digan · Accepted solution]

@bryanmason19 Attached would be a simple Regex solution.