Hi guys,
Would really appreciate any help, have been going round in circles myself and trying to use other answers on forum here without luck so far.
I am trying to pull two specific data points from a text string, I need the "x year" and "y device/node" from the below
The format is slightly different each time, so I need to pull out a number (from 1-5 characters) with a variety of specific words after it (node, year, device) that can be in a different part of the text string each time, below examples
Product Name 50 nodes 1 year > want to isolate "50 nodes" and "1 year"
Product Name 100 nodes license key > want to isolate "100 nodes"
1 Year Product Name Service for 1 device > want to isolate "1 Year" and "1 device"
Thanks for the help,
Rob
