I have a field that is mostly numerical, but can also have text in it, for comments. I have filtered out only the data that I need. I have to perform average calculations on this field. Because the field has both numerical and string values in it, if I change the value field data type to numerical, it will properly average the scores, but will leave out the comments, obviously because it is not a number. If I change the data type to string, the comments are there, but it will not calculate the average.
Is there a way to parse out this data within a single field so that I can average the numbers that I need, while keeping in the comments?