Posts by thenoodly1

That worked beautifully! Thank you!

I have a series of functional locations that can go down to seven levels, separated by '-' within the text. I need to extract the text to the fifth level; however, there is not a standard number of characters per level. E.g.

CT-EJ-844-F-ACP-001-A

CT-EJ-715-A-SS-004

The result I would like for each of those is

CT-EJ-844-F-ACP

CT-EJ-715-A-SS

But of course there's a different number of characters in fifth level (and sometimes in the fourth, too), so instead I would like to eliminate text after the fifth "-" but googling isn't helping me find a way to do that.

TIA for any help!