Text Extraction - Returning specific Values

Hi,

I'm trying to put together a cost estimating spreadsheet and just playing around with ideas at the moment.

Are there any formulas i can use to extract and return specific instances of text where there might be multiple things i want to know?

Lets say I have a ledger where i keep all of my fruit sold at my fruit shop and looks like this;

Johnny bought 5x apples granny smith 3x oranges 3x strawberry

Lisa bought 1x pineapple Large fresh 2x blueberry packaged 1x grape bunch large

Kerry bought 9 x apple loose 1 x Banana bunch 5x kiwi

Is there a formula i can use that would Detect and return to me just the Quantities and type of fruit? The only reason i need this is because i cannot change the way things are entered into the fictional purchase ledger.

I hope this post makes sense!