Extract string from name
Hi, I would like to extract a string of data from a name. The position of the string varies in the name and the name has a variable number of sub-strings within it. An example is shown below: (GPN) CI-4/E7/DH-1 15S-40 L1807
DEO (GPN) JD CI-4/E7/DH-1 5S-40 L1807 (GPN) JD CI-4/E7/DH-1 40 L1807 I am interested in two parts: a string which contains the letter S (so in the examples, 15S-40 & 5S-40) A...
msharp