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.
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: