I currently use the MID function in a formula to parse out a field in a report to a usable value, but the problem now is we are running out of number combinations which has added an extra value sometimes in the field am parsing.

Today I take '0501741_HY44T90' and using mid ({LOC.NAME},2,1)& mid ({LOC.NAME},4,2)&"-"& mid({LOC.NAME},6,2)& mid ({LOC.NAME},9,2) and create '517-41HY'

I need to now take '09002410HY10010' and create '902-410HY'

I need the formula field to be able to do both since we now have a mix. Any insight that could be offered would be appreciated.

Thanks


Edited by ridershaun - 06 Jul 2018 at 3:50am

Thank you