Hi, I’m hoping someone can help me, I have reports that come through daily with identification numbers that contain a mix of letters and numbers, and I need to format them with dashes to be able to import into another program.  

Raw data looks like this:  

HFMRBT0N480020HFMRBT0J0C0005HFMRBT0MXJ0010HFMRBT0NL80006AHFMRBT0NL80006B

And I need output to be:

HFM-RBT-0N48-0020

HFM-RBT-0J0C-0005

HFM-RBT-0MXJ-0010

HFM-RBT-0NL8-0006A

HFM-RBT-0NL8-0006B

Would anyone have a simple-ish solution??

Thanks a lot!
Amy

​Hi, I’m hoping someone can help me, I have reports that come through daily with identification numbers that contain a mix of letters and numbers, and I need to format them with dashes to be able to import into another program.   Raw data looks like this:  HFMRBT0N480020HFMRBT0J0C0005HFMRBT0MXJ0010HFMRBT0NL80006AHFMRBT0NL80006B And I need output to be:HFM-RBT-0N48-0020HFM-RBT-0J0C-0005HFM-RBT-0MXJ-0010HFM-RBT-0NL8-0006AHFM-RBT-0NL8-0006B Would anyone have a simple-ish solution?? Thanks a lot!Amy  Read More

​