Trimming Irrelevant Data

Hi all,

I need some help. I have a table contaning a fair few fields, one of which is [EmployeeName]. This field has bits of irrelavant data joined together with the employee names which i'd like to get rid off through either a query or vba. I know exactly what the irrelevant data items are i.e. "Manager" and "1"

For example: "John Smith Manager" needs to become "John Smith"
For example: " John Smith1" needs to also become "John Smith"
For example: "Mary Smith 1" needs to also become "Mary Smith"

Any help would be greatly appreciated, as at the minute, I'm using the find and replace function in the table view, which I'm having to do daily :-(

Thank you so much,

Jase

re: Trimming Irrelevant Data

Maybe you need to look at why you are having to do this daily, instead of how code can fix this. Any code I could give you would only be emulating the find and replace function, and so would still have to be run daily (maybe it could be done automatically, but that's not the point).

You need to look at the input to the database, and figure out why this keeps happening.

re: Trimming Irrelevant Data

Unfortunately, the population of the data output is beyond my control, and if i could get hold of some code, atleast it could be scheduled to run daily, rather than a manual fix each day. Any help would be appreicated

re: Trimming Irrelevant Data

Try this, and let me know if you have any problems: