
| Welcome to The Dragon Realm. a place for dollers to share their most fav tuts ^_^ |
| Measure text occurrences MS Access SQL | |
|---|---|
| Tweet Topic Started: Jan 10 2018, 02:19 AM (4 Views) | |
| BrianPugh | Jan 10 2018, 02:19 AM Post #1 |
|
newborn dragon
|
Hi, I was wondering whether it is possible (and if it is, the way) to perform the following task in Microsoft Access: there are two tables; first one consists of three columns 1) ID 2) tweet text and 3) date. Second table is a single vector of words, like a lexicon. For every row of the first table, I want to measure occurrences of the words of the second table (lexicon) in the tweet text column (2). Following, I want to add a new column in the first table, in which I will keep a record of these occurrences. My ultimate purpose is to perform some sort of sentiment analysis. Please Help. Thanks, for more you can check: References: https://www.cnet.com/forums Corporate Motion Graphics animation |
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · general chat · Next Topic » |
| Theme: serenity | Track Topic · E-mail Topic |
3:19 PM Jul 11
|






3:19 PM Jul 11