Search results

Almost there (THANKS!!!) However this returns the occurrences based on the lexicon terms. Let me give you an example of what I am looking for: Lets say I have these three tweets: a) I love ice cream and I like summer b) I like apples c) I have no prior SQL knowledge so thanks very much And the...

. Although this is a big first step (THANKS!!!), here is what it does not going right. I want a summative count for each row of the initial tweet_text field. For example, lets say i have 10 entries in the respective field, I need 10 different counters (one for each row), counting matches...

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 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...