Hello:
I have a requirement to pass the FirstName, LastName, Middle Name, Suffix and Degree fields without periods or commas to a spreadsheet...
I want to run a query to parse out the periods and the commas - here is an example of the data I need to cleanup
I need to pass to the spreadsheet
Any recommendations on an update query that will do the trick to the output table that is created from the master called "Candidates" (we can not take the periods and commas out of the the master table) just out of the one I create to output to excel - let me hear from ya.
Thanx
John Kolker
Programmer
jwkolker@comcast.net
I have a requirement to pass the FirstName, LastName, Middle Name, Suffix and Degree fields without periods or commas to a spreadsheet...
I want to run a query to parse out the periods and the commas - here is an example of the data I need to cleanup
Code:
Norman H. Liu Jr. M.D.
First MI Last Suffix Degree
I need to pass to the spreadsheet
Code:
Norman H Liu Jr MD
First MI Last Suffix Degree
Any recommendations on an update query that will do the trick to the output table that is created from the master called "Candidates" (we can not take the periods and commas out of the the master table) just out of the one I create to output to excel - let me hear from ya.
Thanx
John Kolker
Programmer
jwkolker@comcast.net