Hi All,
I am trying to build a crosswalk of job titles so that the resulting values are confined to 6 characters in length. In essence I am looking to abbreviate job titles to 6 characters. Is there a text formula that can help accomplish this?
Below are some of the actual job titles (disregard the duplicates). I was thinking of using some type of rule to standardize this process. For example, in the case of one word titles, use the first 5 characters of the word then the last character, so that ABSTRACTOR = ABSTRR. For one word titles plus a level indicator use the first 5 letters of the first word followed by the first letter of the level indicator, so that ACCOUNANT I = ACCOUNI. Or perhaps keep the first letter of each word then remove the vowels then use the first 6 characters remaining, etc. so that ABSTRACTOR = ABSTRC.
Any help would be very much appreciated!!!!!!!
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
I am trying to build a crosswalk of job titles so that the resulting values are confined to 6 characters in length. In essence I am looking to abbreviate job titles to 6 characters. Is there a text formula that can help accomplish this?
Below are some of the actual job titles (disregard the duplicates). I was thinking of using some type of rule to standardize this process. For example, in the case of one word titles, use the first 5 characters of the word then the last character, so that ABSTRACTOR = ABSTRR. For one word titles plus a level indicator use the first 5 letters of the first word followed by the first letter of the level indicator, so that ACCOUNANT I = ACCOUNI. Or perhaps keep the first letter of each word then remove the vowels then use the first 6 characters remaining, etc. so that ABSTRACTOR = ABSTRC.
Any help would be very much appreciated!!!!!!!
ABSTRACTOR</SPAN> |
ACCOUNTANT I</SPAN> |
ACCOUNTANT I</SPAN> |
ACCOUNTANT I</SPAN> |
ACCOUNTANT II</SPAN> |
ACCOUNTANT II</SPAN> |
ACCOUNTANT II</SPAN> |
ACCOUNTANT III</SPAN> |
ACCOUNTANT III</SPAN> |
ACCOUNTANT III</SPAN> |
ACCOUNTING CLERK II</SPAN> |
ACCOUNTING CLERK II</SPAN> |
ACCOUNTING CLERK II</SPAN> |
ACCOUNTING CLERK III</SPAN> |
ACCOUNTING CLERK III</SPAN> |
ACCOUNTING CLERK III</SPAN> |
ACCOUNTING CLERK TRAINEE</SPAN> |
ACCOUNTING CLERK TRAINEE</SPAN> |
ACCOUNTING CLERK TRAINEE</SPAN> |
ACCOUNTING MANAGER</SPAN> |
ACCOUNTING MANAGER</SPAN> |
ACCOUNTING MANAGER</SPAN> |
ADMINISTRATIVE SPECIALIST</SPAN> |
ADMINISTRATIVE SPECIALIST</SPAN> |
ADMINISTRATIVE SPECIALIST</SPAN> |
ADOPTION/RESCUE COORDINATOR</SPAN> |
ADULT DAY CARE AIDE</SPAN> |
ADULT SERVICES AIDE</SPAN> |
ADVANCED TRANSPORTATION WORKER</SPAN> |
AGING SERVICES PROJECT COORDINATOR</SPAN> |
AGING SERVICES SPECIALIST</SPAN> |
AIRCRAFT & POWER PLANT MECHANIC</SPAN> |
AIRPORT DISPATCHER II</SPAN> |
AIRPORT DISPATCHER TRAINEE</SPAN> |
AIRPORT DISPATCHER-OPERATIONS</SPAN> |
AIRPORT DISPATCHER-PUBLIC SAFETY</SPAN> |
AIRPORT POLICE CORPORAL</SPAN> |
AIRPORT POLICE LIEUTENANT</SPAN> |
AIRPORT POLICE OFFICER</SPAN> |
AIRPORT POLICE OFFICER TRAINEE</SPAN> |
AIRPORT POLICE SERGEANT</SPAN> |
AIRPORT SYSTEMS AUTOMATION TECHNICIAN</SPAN> |
AIRPORT SYSTEMS ENGINEERING TECHNICIAN I</SPAN> |
AIRPORT SYSTEMS ENGINEERING TECHNICIAN II Thanks, Wilkc</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>