Extracting a number from a text field
I have a column containing text notes entered by technicians. They enter the system usage hours, which I need to extract into it's own column. Fortunately, the data is pretty consistent, and so I have been able to pull the info out using Regex Match(), but selecting the last value is tripping me up.Regex Match( :diagnosis, "(ys.+sage: ?)(\d{1,5})\n" );How do I extract the System Usage hours from t...