Formula to match format in column with multiple formats and replace with specific portion.

[BethA]

Original column has content with multiple alpha numerical formats. I want to create a new column that finds the invoices with the specific format 0######-# and for those only, drop the leading 0, and also the -# at the end.   All other invoices should be the same.

I did it as a 2 step formula tool in the attached flow.  The first formula drops the leading 0 for the 0######-# formats. 

The 2nd formula finds the format ######-# and should return only the first 6 digits.  It works for some but not others. I don't know why this isn't working for all of the target formatted items in the 2nd formula.  I also did a cleanse tool to try to clear out any extra info, but it doesn't seem to make a difference.

What is the correct format for the 2nd formula so all matched formats will return only the left 6 digits?

Below are two samples of the original and output column.  Why do some of the revised invoices retain the -# ending and others are correct and just the 6 digits? 

Your help is much appreciated.  Thank you in advance!

[BethA]

First formula

2nd formula

[atcodedog05]

Hi @BethA 

I am guessing you have found the solution. Please mark your post as accept solution so that we know this question is already solved.

Happy to help : )

Cheers and have a nice day!

[BethA]

I still need help. The formulas are from me, they are the ones not working.  Thanks.

[atcodedog05 · Accepted solution]

Hi @BethA 

Try this formula. It seems to work.

Hope this helps : )

[BethA]

Thank you!  

[Akash__on]

I loved this solution 😊