What this blog post wants to share with you is to use the LIKE operator to make a fuzzy match query data source commodity code contains numbers.
650) this.width=650; "style=" Float:none; "title=" 1.JPG "src=" http://s3.51cto.com/wyfs02/M02/6E/51/ Wkiol1v5qmaqkgz2aag3bhfakh4068.jpg "alt=" Wkiol1v5qmaqkgz2aag3bhfakh4068.jpg "/>
To connect to a data source using Microsoft Query, please refer to the first blog post in this series. Statements such as
Which like '%[0-9]% '
650) this.width=650; "style=" Float:none; "title=" 2.JPG "src=" http://s3.51cto.com/wyfs02/M00/6E/55/ Wkiom1v5pytjfvzyaamqyugd0v4452.jpg "width=" 726 "height=" 398 "alt=" wkiom1v5pytjfvzyaamqyugd0v4452.jpg "/>
Execution results are as follows
650) this.width=650; "style=" Float:none; "title=" 3.JPG "src=" http://s3.51cto.com/wyfs02/M01/6E/51/wKioL1V5QM_ Htf6gaakcjqnmmqe898.jpg "alt=" Wkiol1v5qm_htf6gaakcjqnmmqe898.jpg "/>
The results are then imported into the sheet of Excel
650) this.width=650; "style=" Float:none; "title=" 4.JPG "src=" http://s3.51cto.com/wyfs02/M01/6E/55/ Wkiom1v5pyvim9ysaadanb7icg8126.jpg "alt=" Wkiom1v5pyvim9ysaadanb7icg8126.jpg "/>
This article is from the "Guo Yong Technology blog" blog, make sure to keep this source http://guoyong.blog.51cto.com/408495/1660924
Querying data using SQL statements in Excel (vii)-----fuzzy matching query with like operator