Yup... I agree... -----Original Message----- From: windows2000-bounce@xxxxxxxxxxxxx [mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Angus Macdonald Sent: Thursday, November 13, 2003 9:58 AM To: windows2000@xxxxxxxxxxxxx Subject: [windows2000] Re: OT: Programming question I don't think you'll manage it without a program equivalent to an experienced human brain. You'd need a lookup table of all possible surnames and that isn't going to happen. You're trying to program around a data quality issue. -----Original Message----- From: Rick Fogarty [mailto:rick@xxxxxxxxxxxxx] Sent: 13 November 2003 14:52 To: windows2000@xxxxxxxxxxxxx Subject: [windows2000] Re: OT: Programming question So you see my dilemma.... It boils down to some type of artificial intelligence that I'd have to program.... I thought of scanning for De Los blah blah blah. But then I saw names like Mac Intosh, Mc Whorter etc... At least I'm not going crazy, you see the boat that I'm in... -----Original Message----- From: windows2000-bounce@xxxxxxxxxxxxx [mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Costanzo, Ray Sent: Thursday, November 13, 2003 9:38 AM To: windows2000@xxxxxxxxxxxxx Subject: [windows2000] Re: OT: Programming question This is another one of those situations, so it sounds, that there isn't a 100% method. What if your file is: Jo Ann Smith Jose Los Santos Jo Ann is the first person's first name, Los Santos is the second person's last name. There is no way to distinguish this, unless you have the ability to think. So, while you and I can distinguish it as thinkers, the computer cannot. Is it possibly to have your source file come in a different way? Like, with comma delimiting between first and last names or some other way of distinguishing things? Ray at work -----Original Message----- From: Rick Fogarty [mailto:rick@xxxxxxxxxxxxx] Some time ago I presented a question concerning parsing names in a data file. I've got it working perfectly except for the following: Currently, the parsing routine uses delimiters (spaces, commas etc) to determine what separates the values (such as first name, middle name etc.) So, John L. Jones Jr is pretty simple. I'm having problems with names like this.... Juan Lopez De Los Santos The Juan and Lopez are fine, however, it's reading the De Los Santos as three separate entities as its programmed to do... I'm just wondering if there might be a better way to do this so I can get De Los Santos into the last name field. **************************************************************************** ****************************** The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. Distribution, publication, or retransmission of this message is strictly prohibited. This message may be a bank to client communication and as such is priviliged and confidential. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. The sender of this e-mail specifically "opts-out" of the Electronic Signatures and Global and National Commerce Act (E-Sign) and any and all similar state and federal acts. Accordingly, but without limitation, any and all documents, contracts, and ageements must contain a handwritten signature of the sender to be legal, valid, and enforceable. **************************************************************************** ****************************** ******************************************************** This Weeks Sponsor Pearl Software Internet Monitoring, Filtering, and Control Solutions Enabling User & Group Level Oversight & Access Policies Fully Functional in a Thick or Thin Client Environment http://www.pearlsw.com ********************************************************** To Unsubscribe, set digest or vacation mode or view archives use the below link. http://thethin.net/win2000list.cfm ******************************************************** This Weeks Sponsor Pearl Software Internet Monitoring, Filtering, and Control Solutions Enabling User & Group Level Oversight & Access Policies Fully Functional in a Thick or Thin Client Environment http://www.pearlsw.com ********************************************************** To Unsubscribe, set digest or vacation mode or view archives use the below link. http://thethin.net/win2000list.cfm ******************************************************** This Weeks Sponsor Pearl Software Internet Monitoring, Filtering, and Control Solutions Enabling User & Group Level Oversight & Access Policies Fully Functional in a Thick or Thin Client Environment http://www.pearlsw.com ********************************************************** To Unsubscribe, set digest or vacation mode or view archives use the below link. http://thethin.net/win2000list.cfm ******************************************************** This Weeks Sponsor Pearl Software Internet Monitoring, Filtering, and Control Solutions Enabling User & Group Level Oversight & Access Policies Fully Functional in a Thick or Thin Client Environment http://www.pearlsw.com ********************************************************** To Unsubscribe, set digest or vacation mode or view archives use the below link. http://thethin.net/win2000list.cfm