Hi, using a query I need to be able to extract a code from within a character string. There can be several thousand lines, each with a different code but the format is always the same ####-. Here is an example:
Desc
10-403 Sal-RecruitInit 1485- Staff Recharge
10-413 Sales- Creative 1239- Specs UK advert
10-415 Marketing Man 1239- Specs UK advert
10-416 SaleProfPublica 1152- Professional Ma
10-416 SaleProfPublica 1153- Optom Career Pa
10-416 SaleProfPublica 1938- ODP Income
10-416 SaleProfPublica 1947- Nat Sem Inc
10-417 Sales - Recall 1239- Specs UK advert
10-421 Sales-Training 1048- Emplymnt Law Ma
10-421 Sales-Training 1049- Rectmnt Mat Inc
10-421 Sales-Training 1161- SmartBus RS In
10-421 Sales-Training 1215- Tra Fees - Gen
10-421 Sales-Training 1327- Conducting Staf
From line 1 I would be extracting 1485, line 2 1239 and so on.
Your help would be much appreciated.
Open in new window