To find out if a string contains substring you can use the index function: if (index($str, $substr) != -1) { print “$str contains $substr\n”; } It will return the position of the first occurrence of $substr in $str, or -1 if the substring is not found.
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 tried using existing fuzzy libraries like fuse.js and also found them to be terrible, so I wrote one which behaves basically like sublime’s search. https://github.com/farzher/fuzzysort The only typo it allows is a transpose. It’s pretty solid (1k stars, 0 issues), very fast, and handles your case easily: fuzzysort.go(‘int’, [‘international’, ‘splint’, ‘tinder’]) // [{highlighted: ‘*int*ernational’, … Read more
Simon White of Catalysoft wrote an article about a very clever algorithm that compares adjacent character pairs that works really well for my purposes: http://www.catalysoft.com/articles/StrikeAMatch.html Simon has a Java version of the algorithm and below I wrote a PL/Ruby version of it (taken from the plain ruby version done in the related forum entry comment … Read more
In case you’re interested in a quick visual comparison of Levenshtein and Difflib similarity, I calculated both for ~2.3 million book titles: import codecs, difflib, Levenshtein, distance with codecs.open(“titles.tsv”,”r”,”utf-8″) as f: title_list = f.read().split(“\n”)[:-1] for row in title_list: sr = row.lower().split(“\t”) diffl = difflib.SequenceMatcher(None, sr[3], sr[4]).ratio() lev = Levenshtein.ratio(sr[3], sr[4]) sor = 1 – distance.sorensen(sr[3], … 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
exec returns an object with a index property: var match = /bar/.exec(“foobar”); if (match) { console.log(“match found at ” + match.index); } And for multiple matches: var re = /bar/g, str = “foobarfoobar”; while ((match = re.exec(str)) != null) { console.log(“match found at ” + match.index); }
import re pattern = re.compile(“^([A-Z][0-9]+)+$”) pattern.match(string)
Now with PHP 8 you can do this using str_contains: if (str_contains(‘How are you’, ‘are’)) { echo ‘true’; } RFC Before PHP 8 You can use the strpos() function which is used to find the occurrence of one string inside another one: $a=”How are you?”; if (strpos($a, ‘are’) !== false) { echo ‘true’; } Note … Read more