 |
Recently we were completing a submission for a major Canadian survey. The vendors had thoughtfully recoded all their job codes which of course caused some distress for our internal tools. The job codes changed from a form like 0021, 0125 to a code incorporating both job function and job number, something like AD for administration and 12 for the job code. Unfortunately for us we coded the new jobs in the form AD12 and the vendor had added a hyphen creating the following form: AD-12. In order to use a Vlookup to fill their submission data sheet, we needed exact mapping. Oops what a pain. |
