S
suz
I need to parse the first 7 chars of last name from name field (ie. first
last, first middle last), however the last name can have a hyphen and or
multiple names.
Examples:
Joe De La Paz result needs to be DELAPAZJ (this one is tough because it was
entered with spaces between De La Paz)
Crystal Bakersmith result needs to be BAKERSMC
Sally Mahone-Lamm result needs to be MAHONES
Chan Ven Kaliq Kada result needs to be KADAC
last, first middle last), however the last name can have a hyphen and or
multiple names.
Examples:
Joe De La Paz result needs to be DELAPAZJ (this one is tough because it was
entered with spaces between De La Paz)
Crystal Bakersmith result needs to be BAKERSMC
Sally Mahone-Lamm result needs to be MAHONES
Chan Ven Kaliq Kada result needs to be KADAC