Extract Reel name from Venice clipnames (string)

Hi!
I need to extract the first 8 letters of the following Sony Venice clipname to fill the reel column.
What would be the correct string?
example: T001C001_2104231Y
to extract: T001C001
thanks!
Lew
I need to extract the first 8 letters of the following Sony Venice clipname to fill the reel column.
What would be the correct string?
example: T001C001_2104231Y
to extract: T001C001
thanks!
Lew