Trying to figure out how to make a label expression.
“Project Stream # W_2506_2.0; Fed by karst resurgence;” in the Comments field, I want the label to display as “W_2506_2.0” on the map.
Try something like this: Split Label in ArcMap
In your case, you'll need to do two splits, "# " and ";". That is, assuming the comment always has the format "Something # Label; Something".
Try this Label Expression (Parser: VBScript)
split((split( [Comments],"#" )(1)),";")(0)
Retrieving data ...