What are the criteria for determining which part of the string you want?
Do you want the digits from the fourth field, using underscore as the field delimiter?
Do you want whatever follows C up to S?
BTW, you don't want to use sed to work on a string.
Use sed for working on files and shell parameter expansion for manipulating strings.