Create a string function to extract: Suffix & Middle name based on the alpha name
Alpha format: FNAME, LNAME, MI, SUFFIX
Input data sample - alpha field:
Input Alpha MI SUFFIX
BARBER,RAYMOND,,JR blank 05 RICE,NARBERTH,,JR blank 05 REED,CHRISTOPHER,JR blank 05
ROSS JR,LOUIS,A A blank
BERNARD,KENNETH,A,JR A 05 MATOS,EDWIN,F,JR F 05
CALDWELL,ARTHUR,LEE,JR ARTHUR LEE 05
CALDWELL,ARTHUR,LEE,SR ARTHUR LEE 06
CAL,AT,B,III AT B 03
Suffix conversion codes:
02 <= II
03 <= III
04 <= IV
05 <= Jr.
06 <= Sr.
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement).
## Platform
aix, db2 udb v 9
The coder must be proficient in db2 udb function writing.
Please don’t bid unless you understand what needs to be done.