Parse out different size numbers in various spots in a string

Question

Hi,

I've been trying to search through the community but can't seem to get what I need.  In the below table, under "Machine", I am trying to just pull out the model #s but they are not in consistent locations in the string.  Can someone help in pulling these out?

Machine[new] Model # Onlyneed07E4h Probably Evo 510 510HP Compaq dc7100 SFF(PS026US) 7100HP rp5800 5800HP RP5 Retail System Model 5810 5810HP Compaq dc7800 Small Form Factor 7800HP Compaq dc7100 SFF(PS026US) 7100HP RP5 Retail System Model 5810 5810

Thanks in advance!

Verakso · Accepted Answer

RegEx can be you friend here

There is plenty of tutorials on this here in the Community.

I am no RegEx master myself but this pattern:

(\d{3,4})

Did the trick on you sample data

/Verakso