A
ar013871 via AccessMonster.com
Okay, here's what I'm running into. We have a HUGE CSV file whose data is
just not formatted in a good way. For example:
Smith,Joe
Smith, Joe
Smith\, Joe
All represent the same person, however, hase three different records. What
I'm wanting to do is run an Update statement that would make all the names be
formatted as Last,First with no space after the comma. Thoughts?
just not formatted in a good way. For example:
Smith,Joe
Smith, Joe
Smith\, Joe
All represent the same person, however, hase three different records. What
I'm wanting to do is run an Update statement that would make all the names be
formatted as Last,First with no space after the comma. Thoughts?