How about dumping the contents of the database, then using grep? $ pg_dump –data-only –inserts -U postgres your-db-name > a.tmp $ grep United a.tmp INSERT INTO countries VALUES (‘US’, ‘United States’); INSERT INTO countries VALUES (‘GB’, ‘United Kingdom’); The same utility, pg_dump, can include column names in the output. Just change –inserts to –column-inserts. That … Read more
I wouldn’t use Spark in the first place, but if you are really committed to the particular stack, you can combine a bunch of ml transformers to get best matches. You’ll need Tokenizer (or split): import org.apache.spark.ml.feature.RegexTokenizer val tokenizer = new RegexTokenizer().setPattern(“”).setInputCol(“text”).setMinTokenLength(1).setOutputCol(“tokens”) NGram (for example 3-gram) import org.apache.spark.ml.feature.NGram val ngram = new NGram().setN(3).setInputCol(“tokens”).setOutputCol(“ngrams”) Vectorizer (for … Read more
Here is a solution using the fuzzyjoin package. It uses dplyr-like syntax and stringdist as one of the possible types of fuzzy matching. As suggested by @C8H10N4O2, the stringdist method=”jw” creates the best matches for your example. As suggested by @dgrtwo, the developer of fuzzyjoin, I used a large max_dist and then used dplyr::group_by and … Read more
The -Contains operator doesn’t do substring comparisons and the match must be on a complete string and is used to search collections. From the documentation you linked to: -Contains Description: Containment operator. Tells whether a collection of reference values includes a single test value. In the example you provided you’re working with a collection containing … Read more
You need %in% instead of ==: library(dplyr) target <- c(“Tom”, “Lynn”) filter(dat, name %in% target) # equivalently, dat %>% filter(name %in% target) Produces days name 1 88 Lynn 2 11 Tom 3 1 Tom 4 222 Lynn 5 2 Lynn To understand why, consider what happens here: dat$name == target # [1] FALSE FALSE FALSE … Read more
How do I check if a string contains a specific word?
ECMAScript 6 introduced String.prototype.includes: const string = “foo”; const substring = “oo”; console.log(string.includes(substring)); // true includes doesn’t have Internet Explorer support, though. In ECMAScript 5 or older environments, use String.prototype.indexOf, which returns -1 when a substring cannot be found: var string = “foo”; var substring = “oo”; console.log(string.indexOf(substring) !== -1); // true