HelloI have a group of records that have a text comment where I need to extract certain words e.g. need to extract word HOUSE123 HOUSE 12111 HOUSE 25231 35951 HOUSE 30357 78If I say Like HOUSE is downloads all the records with HOUSE in the text but when I run the query I need it to download all the records so I can see the records that have not had HOUSE recorded.The data I am working with has a lot more text than the example above and I am searching for other key words as well so it is a big query.I need to see all the records whether they have had HOUSE recorded or not - data quality check?Does that make sense?Katherine
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Maybe clarify as well. In one part you say you need to "extract" certain words, then say you want to exclude them. Since queries don't "extract" and they can return records where a field does or does not contain data, which is it you need to do?
If you use LIKE *something* you will get everything contains "something" along with whatever comes before or after "something" because of the wild card (*). If you want to return only certain words and nothing else in that field, you have a more complex problem.
If you use LIKE *something* you will get everything contains "something" along with whatever comes before or after "something" because of the wild card (*). If you want to return only certain words and nothing else in that field, you have a more complex problem.
Upvote
0
Similar threads
