EXTRACT_WORDS
- Juliane Wetzel
- Konsta Danyliuk (Deactivated)
Owned by Juliane Wetzel
Syntax
EXTRACT_WORDS(<text>)
Description
Converts text to a list of words using a preconfigured maximum entropy tokenizer. Punctuation is removed.
Examples
EXTRACT_WORDS(#Text_Column)
Text column | EXTRACT_WORDS returns |
|---|---|
| Unhappily for his master, as well as himself, his curiosity drew him unconsciously farther off than he intended to go. At last, having seen the Parsee carnival wind away in the distance, he was turning his steps towards the station, when he happened to espy the splendid pagoda on Malabar Hill, and was seized with an irresistible desire to see its interior. He was quite ignorant that it is forbidden to Christians to enter certain Indian temples, and that even the faithful must not go in without first leaving their shoes outside the door. It may be said here that the wise policy of the British Government severely punishes a disregard of the practices of the native religions. | [Unhappily, for, his, master, as, well, as, himself, his, curiosity, drew, him, unconsciously, farther, off, than, he, intended, to, go, At, last, having, seen, the, Parsee, carnival, wind, away, in, the, distance, he, was, turning, his, steps, towards, the, station, when, he, happened, to, espy, the, splendid, pagoda, on, Malabar, Hill, and, was, seized, with, an, irresistible, desire, to, see, its, interior, He, was, quite, ignorant, that, it, is, forbidden, to, Christians, to, enter, certain, Indian, temples, and, that, even, the, faithful, must, not, go, in, without, first, leaving, their, shoes, outside, the, door, It, may, be, said, here, that, the, wise, policy, of, the, British, Government, severely, punishes, a, disregard, of, the, practices, of, the, native, religions] |
Apostrophes for possessive words and contractions aren't removed.
| Text | Result |
|---|---|
| I think that is Jason's baseball. | [I, think, that, is, Jason's, baseball] |
| We're going to get pizza after the game! | [We're, going, to, get, pizza, after, the, game] |
Symbols standing alone like "@" and "&" are individual tokens in the resulting list.
| Text | Result |
|---|---|
| My email address is services @ datameer.com | [My, email, address, is, services, @, datameer.com] |
| Look over there, it is Jason & Eddie. | [Look, over, there, it, is, Jason, &, Eddie] |
Symbols joined with or within a word result in a token containing that symbol.
| Text | Result |
|---|---|
| My email address is services@datameer.com | [My, email, address, is, services@datameer.com] |
| Look over there, it is Jason&Eddie. | [Look, over, there, it, is, Jason&Eddie] |
Not all symbols joined with words result in a single token.
| Text | Result |
|---|---|
| The baseball cost $50. | [The, baseball cost, $, 50] |
| The importance of #bigdata | [The importance, of, #, bigdata] |