A trading software called Rotman Interactive Trader expresses in Excel crude oil supply messages, the so-called strings, which more or less follow this format:
WEEK 3 CL CURRENT CONSTRUCTION 12 MLB BBLS VS FORECAST CONSTRUCTION 4 MLN BBLS
I basically want to grab the 12 and the 4 and subtract them (12-4 = 8). However, it is also possible that the news:
WEEK 3 CL ACTUAL BUILD 12 MLB BBLS VS FORECAST TO DRAW 4 MLN BBLS
In this example, my calculation would be (12 + 4 = 16). It is also possible that the first BUILD is a DRAW.
Ideally I would like to code a function that returns this array or the like according to the first example.
 = BUILD  = 14  = BUILD  = 4
Unfortunately, I am not fluent in VBA Excel and would like some help or ideas on how to achieve this. All help is appreciated. Many Thanks!