比较地址 [英] Compare address

问题描述

大家好，


我正试图想出一个比较两个表的地址的好方法。示例：表1的地址为12345 E Main St，表2的地址为12345 Main。


我需要查看数字和实际街道。如果他们匹配比我好。我做了以下

展开 | 选择 | Wrap | 行号

解决方案

@ timber910


你好，


首先我想知道为什么你在两张桌子上看到基本相同的信息？您可能在此处遇到一些数据规范化问题。快速浏览一下玛丽的着名文章关于正常化。如果你不习惯它会相当沉重，但是花点时间它会有很大的帮助。


让我们知道在两个表中的地址的原因和我们可以从那里去。


Jim

哈哈！不，不。从其他公司获得客户。所以我得到他们的数据。一个数据库有他们的账单信息（比方说这是table1），第二个数据库是客户信息。转换后，这两个系统都会保留两个不同的系统。相信我，我很想摆脱这些系统中的一个。


我只需要能够匹配两者之间的地址，以便知道我是否遗漏了任何东西或者需要将地址发回给卖家，因为他们太不同了。方向或街道，开车或什么并不重要。只需要匹配数字和实际街道。我会在两个文件中获取信息，我会将它们添加为两个表格，这样我就可以在名称，地址，城市，州，邮政等之间进行匹配等，但最后三个是容易的那个。


继续我当前的查询可以这么说

展开 | 选择 | 换行 | 行号

< blockquote> @ timber910


您可以在Ta中提取[Address]字段的数字分量每个记录的ble1，然后查看它是否包含在Table2中的任何[Address]字段中。然后，您将关键字段值输出到文件，表等。此过程将大大减少手动搜索部分匹配的记录数量。我已经为您完成了部分难题，但如果您需要进一步的帮助，请让我或其他专家/版主/管理员知道。

展开 | 选择 | Wrap | 行号

hello all,

I''m trying to figure out a good way to compare address across two tables. Example: Table 1 has the address of 12345 E Main St and table 2 has 12345 Main.

I need to just look at the numbers and actual street. If they match than I''m good. I''ve done the below

Expand|Select|Wrap|Line Numbers

解决方案

@timber910
Hi Will,

I''d like to know first of all, why you have what appears to be essentially the same information in two tables? You may have some data normalisation problems here. Have a quick glance at Mary''s famous article on normalisation. It''s fairly hefty if you''re unused to it, but take the time and it will help a lot.

Let us know about the reason for addresses in two tables and we can go from there.

Jim

LOL! No, no.. Getting customers from another company. So I''m getting their data. One database has their billing information (lets say this is table1) and the second database is the customer info. Both of these will stay it two different systems after they are converted. Trust me, I would love to get rid of one of these systems.

I just need to be able to match address between the two in order to know if I''m missing anything or need to send address back to the seller becuase they are too different. The directions or street, drive or what not isn''t important. Just need to match the number and the actual street. I''ll get the information in two files and I''ll add them as two tables so i can then do my matching, etc. between name, address, city, state, zip, etc. but the last three are the easy ones.

Heres my current query so to speak

Expand|Select|Wrap|Line Numbers

@timber910
You can extract the Numeric Component of the [Address] Field in Table1 for every Record, then see if it is contained within any of the [Address] Fields in Table2. You would then output the Critical Field values to a File, Table, etc. This process would greatly reduce the amount of Records to manually search for partial Matches. I''ve completed part of the puzzle for you, but if you need further help, just let me or one of the other Experts/Moderators/Admin know.

Expand|Select|Wrap|Line Numbers

这篇关于比较地址的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！