部分字符串匹配两列 [英] Partial string match two columns

问题描述

我有两个表，每个表都有一个表示型号的字符串。我需要创建一个表格，将每个模型显示在另一个模型旁边。一个表包含完整的型号，另一个表包含不同数量的字符。所需的匹配是将完整模型中的部分字符串与较短字符串中的所有字符串相匹配。


sql新手，不知道vba做了什么。对访问qbe有一个公平的理解。版本是2013.


提前谢谢。

I have two tables, each with a string that represents a model number. I need to create a table that shows each model next to the other. One table contains the full model number and the other table has varying numbers of characters missing. The match needed is to match part of the string in the full model to all of the string in the shorter string.

New to sql, have no idea what vba does. Have a fair understanding of access qbe. Version is 2013.

Thanks in advance.

推荐答案

查看INSTR（）函数。在

Look at the INSTR() function. In

展开 | 选择 | Wrap | 行号

谢谢。我对此一无所知，但今天晚些时候我会试一试，让你知道我是怎么做的。

Thank you. I don''t know anything about this but I''ll try it later today and let you know how I do.

Jim，谢谢你的回复 - 对不起，我只是没有得到它。


这是我想要匹配的更好的例子


column1 Columm2

测试车

grapey est

afcarty猿

所需的结果：


afcarty购物车

葡萄猿

test est


非常感谢

Jim, Thanks for your reply -I''m sorry, I just don''t get it.

Here''s a better example of what I''m trying to match

column1 Columm2
test cart
grapey est
afcarty ape

the desired result:

afcarty cart
grapey ape
test est

Thanks much

这篇关于部分字符串匹配两列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！