Welcome Guest [Log In] [Register]





Welcome to The Dragon Realm. a place for dollers to share their most fav tuts ^_^

Username:   Password:
Add Reply
Measure text occurrences MS Access SQL
Topic Started: Jan 10 2018, 02:19 AM (4 Views)
BrianPugh
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
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · general chat · Next Topic »
Add Reply