I have tried several ways to Parse this customer file. Its a bankers database that was sent to me tab delimited. In my name field I have names like:
FIELD1
SHIRLEY CAPUTO/IRA
FBO NORMAN E SCHULTZ JR
MARK RUDERMAN TTEE
LEE J MITCHELL
IRA FBO ELAINE M SCHRUTT
EDWARD WEINBERGER SP
IRA OF MICHAEL PERTESSIS
GERD M. GRACE
I need to get rid of all the junk txt like IRA, SP, OR, TTEE, and such. I also need to grab the first name and send it to another field same with last name. I had the idea to create a junk table with all the junk text to parse that out first. I need some assistance setting up the code to look at the junk table and compare it to my Name table. Then I can hopefully sort out my FNAME and LNAME- Can anyone shed some light, or point me to a better way to accomplish this? Thanks
FIELD1
SHIRLEY CAPUTO/IRA
FBO NORMAN E SCHULTZ JR
MARK RUDERMAN TTEE
LEE J MITCHELL
IRA FBO ELAINE M SCHRUTT
EDWARD WEINBERGER SP
IRA OF MICHAEL PERTESSIS
GERD M. GRACE
I need to get rid of all the junk txt like IRA, SP, OR, TTEE, and such. I also need to grab the first name and send it to another field same with last name. I had the idea to create a junk table with all the junk text to parse that out first. I need some assistance setting up the code to look at the junk table and compare it to my Name table. Then I can hopefully sort out my FNAME and LNAME- Can anyone shed some light, or point me to a better way to accomplish this? Thanks