[AccessD] Back in the saddle

[John Bartow]

Thanks for your help on this issue. It got my brain working a bit more than it had been and I accomplished that task.

However the job continues. Making sense of a bunch of unstructured spreadsheets and a poorly structured data dump from a cloud data system has been intriguing, if not just frustrating, lol. 

Trying to get people to explain the mess they created isn't easy. Cleaning it up isn't easy.

Sincerely, 
John R Bartow
WinHaven Information Technology Services 
Mobile: 920-582-7574

-----Original Message-----
From: AccessD <accessd-bounces+jbartow=winhaven.net at databaseadvisors.com> On Behalf Of John Bartow
Sent: Friday, April 19, 2024 8:00 PM
To: DBA-Access (AccessD at databaseadvisors.com) <accessd at databaseadvisors.com>
Subject: [AccessD] Back in the saddle

I'm using Access again, after many years away. I'm using it to migrate data from one messy cloud based LOB program's data to another messy cloud based LOB program. So I'm basically breaking it down to build it back up again.

I need to compare [client name] (one field) "Joe D. Testguy" to [first name] "Joe" [middle name] "D." [last name] "Testguy" concatenated to be one field for this purpose. I used to use a function to do this and have the result with only 1 space between the 3 parts even if the middle name was null. Can one of you gurus refresh my memory as to how this is done?

That's the fun part. The drag comes when someone put "Joe D Testguy and Jill D Testgal" as the [client name].

TIA
John B

-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com