How to get a button’s height to match another element’s height?
Presumably the EditText and the Button are inside a RelativeLayout. Set the button’s layout attributes to alignTop and alignBottom of the EditText.
match
Excel – VLOOKUP vs. INDEX/MATCH – Which is better?
I prefer to use INDEX/MATCH in practically every situation because it is far more flexible and has the potential to be much more efficient depending on how large the lookup table is. The only time when I can really justify using VLOOKUP is for very straight-forward tables where the column index number is dynamic, although … Read more
compare two lists in python and return indices of matched values
The best way to do this would be to make b a set since you are only checking for membership inside it. >>> a = [1, 2, 3, 4, 5] >>> b = set([9, 7, 6, 5, 1, 0]) >>> [i for i, item in enumerate(a) if item in b] [0, 4]
Regex to match only uppercase “words” with some exceptions
To some extent, this is going to vary by the “flavour” of RegEx you’re using. The following is based on .NET RegEx, which uses \b for word boundaries. In the last example, it also uses negative lookaround (?<!) and (?!) as well as non-capturing parentheses (?:) Basically, though, if the terms always contain at least … Read more
What does the “Nothing to repeat” error mean when using a regex in javascript?
You need to double the backslashes used to escape the regular expression special characters. However, as @Bohemian points out, most of those backslashes aren’t needed. Unfortunately, his answer suffers from the same problem as yours. What you actually want is: The backslash is being interpreted by the code that reads the string, rather than passed … Read more
Arrays and -contains – test for substrings in the elements of an array
It looks like your misconception was that you expected PowerShell’s -contains operator to perform substring matching against the elements of the LHS array. Instead, it performs equality tests – as -eq would – against the array’s elements – see this answer for details. In order to perform literal substring matching against the elements of an … Read more
Matching similar but not exact text strings in Excel VBA projects
I would place the macro in your PERSONAL section, this way the macro is available in all worksheets. Do this by recording a dummy macro and select to store it in Personal Macro workbook. Now you can manually add new macro’s and functions in this personal workbook. I just tried this one (don’t know the … Read more
In Perl, is there a built in way to compare two arrays for equality?
There is the new smart match operator: #!/usr/bin/perl use 5.010; use strict; use warnings; my @x = (1, 2, 3); my @y = qw(1 2 3); say “[@x] and [@y] match” if @x ~~ @y; Regarding Array::Compare: Internally the comparator compares the two arrays by using join to turn both arrays into strings and comparing … Read more
Case insensitive search in Mongo
You can Use $options => i for case insensitive search. Giving some possible examples required for string match. Exact case insensitive string db.collection.find({name:{‘$regex’ : ‘^string$’, ‘$options’ : ‘i’}}) Contains string db.collection.find({name:{‘$regex’ : ‘string’, ‘$options’ : ‘i’}}) Start with string db.collection.find({name:{‘$regex’ : ‘^string’, ‘$options’ : ‘i’}}) End with string db.collection.find({name:{‘$regex’ : ‘string$’, ‘$options’ : ‘i’}}) Doesn’t … Read more