问题描述
我正在使用包含名称和地址的大型数据库。我被要求在Access中创建一个例程，用于标准化地址中的特定单词，如St，Str，St。（Street）和Ave，Ave。 （大道）多做一个查找和替换。我已经尝试创建更新查询，但最终替换了整个字段而不是目标字。我想尝试创建一个可以执行查找和请求的宏，但需要帮助。此例程将定期用于大约500,000条记录。
I am working with a large database that contains names and addresses. I have been asked to create a routine in Access that would be used to standardize specific words in the address such as St, Str, St. (Street) and Ave, Ave. (Avenue) and more by doing a find and replace. I have tried creating an update query, but ended up replacing the whole field instead of the targeted word. I would like to try creating a macro that could do the find and reqplace, but need help with this. This routine would be used on a regular basis on approximately 500,000 records.
推荐答案
这篇关于如何大规模地对部分数据执行查找和替换？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！