216 questions
3
votes
3
answers
210
views
Looping within 4 columns to find an exact match of my array
I am working on a new Excel macro through VBA.
The idea of the macro is to hide all the rows that doesn't contain an exact match of the string provided.
By exact match, I mean it should only be that. ...
- 396
0
votes
2
answers
538
views
How to make PowerShell `Select-String` aka `sls` output exact match(es) only?
In a PowerShell script, I would like to check if a branch exists locally already, which I'm currently doing as $existsInLocal = (git branch | sls $branch) -ne $null, but that's incorrect because sls $...
- 1,013
0
votes
1
answer
127
views
r(101): trying to advance in my thesis and I have encountered this error while doing a loop
I have written Stata code for an exact matching of children with mental health problems with children without mental health problems on sex (males, females) and age (3, 4 and 5 years of age). I want ...
0
votes
1
answer
68
views
Include files/folders in zip in powershell upon exact Match
Below are my files
1. C:\Temp\src\config\1.txt
2. C:\Temp\src\logs\wowconfigls\3.txt
The user wants to include the files/folders that exactly match either canweb.war or config.
Thus, $itemsToInclude =...
- 3,195
0
votes
1
answer
2k
views
How can I select an element by exact text using Cypress? [duplicate]
I have a table with a widget name column, followed by other columns with detail about the widgets.
I have a search function on the page to search for the widget that I want by name. When I search for ...
- 42
1
vote
2
answers
387
views
Why is my XLOOKUP, with a nested MAXIFS, unable to give me an exact match?
First off, here is my formula:
=XLOOKUP(MAXIFS(D:D,E:E,">0"),(B:B=F2)*(A:A="EFP")*D:D,C:C,,-1)
CAMPAIGN
RECORD PHONE#
REP #
PAYMENT DATE
PAYMENT AMT
LEAD PHONE NUMBER
LASTREP
...
- 127
0
votes
0
answers
71
views
How do I make summarize(count_by_) in dplyr only count instances if there is an exact match?
I am trying to make a pivot table of a large .tsv data set in R and exporting it back to Excel.
I tried using the dplyer functions:
summary <- df %>%
group_by(Run,Prot) %>%
summarize(...
- 1
2
votes
3
answers
225
views
How to count exact matches across two data frames within IDs in R
I have two datasets similar to the one below (but with 4m observations) and I want to count the number of matching sample days between the two data frames (see example below).
DF1
...
- 21
-1
votes
1
answer
807
views
How to Exact Match a list of words in a list of strings Google Apps Script
This is my first time using Stack Overflow. I am a beginner level JavaScript/Google App Script coder.
I have a list of products that my app reads from 'Product' sheet and a list of keywords coming ...
1
vote
4
answers
4k
views
Python: How to determine if a string has an exact match with any string from the list
Assume that I have the list of phrases to compare against as:
["hello", "hi", "bye"]
I want to return true if my text has any of this words in it, but with exact match. ...
- 309
1
vote
3
answers
382
views
Finding the exact match in the values in the categorical variables
I wanted to find an exact match in the values between all three columns (rg1,rg2,rg3).Below is my dataframe.
For instance - first row has a combination of (70,71,72) , if this same combination ...
- 25
0
votes
1
answer
2k
views
kmatch: Check propensity scores and individuals who are matched
I'm using kmatch in Stata. The reason why I use kmatch is to use the command ematch to match exactly on a specific variable in addition to the propensity score matching. Here is my code:
kmatch ps ...
- 93
0
votes
0
answers
644
views
Stata: how to treat numerical values as categorical values in CEM?
In my data, I have a variable of income level, which is 1,2,3,4,5,6,7, 8, and 9. I am wondering if I directly put this variable in imb or cem without recoding as illustrated in the manual, will the ...
- 728
0
votes
3
answers
2k
views
python: return the exact match from list of values in a dictionary
I have a dictionary as follows:
dictionary = {'happen1':['happen later'], 'happen2':['happen'], 'happen3':['happen later',' happen tomorrow'], 'happen4':['happen now'], 'happen5':['happen again','...
- 911
1
vote
1
answer
2k
views
Replace exact part of file name with Powershell
I tried the code found here without success.
What I need is to replace an exact text with another, but this code doesn't seem to deal with exact text.
This is the code I used, and what I need is, for ...
- 13
0
votes
1
answer
987
views
Coarsened exact matching with MatchIt
I am running the coarsened exact matching (cem) matching method from the MatchIt package on a dataset that contains ~18,300 rows (i.e., one row for each patient). I am matching patient cases on two ...
- 45
1
vote
1
answer
1k
views
How to match a line with exactly n occurrences with regex?
I am trying to match the lines containing exactly two semicolons (using Pythons re library):
text;text;text;
text;text;
text;text;text;text;
text;text;
However, I can't figure out how to not also ...
- 57
0
votes
1
answer
526
views
MySQL: Match Only Exact Strings in a String from a Table of Key Strings
I'm trying to match words from a table to a string when only the exact word matches, I've only been able to get very loose match so far by using a LIKE statement and it matches most things but the ...
- 2,503
0
votes
2
answers
647
views
Trouble converting "for key in dict" to == for exact matching
Good morning,
I am having trouble pulling the correct value from my dictionary because there are similar keys. I believe I need to use the == instead of in however when I try to change if key in ...
- 83
0
votes
1
answer
87
views
Elastic - Only return fully matching documents
Having the following dataset:
[
{
"id": 234,
"category": "shoe"
},
{
"id": 44,
"category": "shoes"
},
{
"id": 49,
"...
- 737
1
vote
1
answer
192
views
Search a word and Get Predictive Search Words from String (not complete string) in Mysql
I have SQL Table Design like Listed Below
*-----------------------------------------
| id | title |
| -- | -----------------------------------|
| 1 | This is nice pen ...
- 490
2
votes
0
answers
644
views
Match solr documents with exact one value in an multi valued field
I have an solr index with an multivalued field named colors, where all the colors stored, related to the document, like:
colors: ["blue","red"]
colors: ["blue" "...
- 13.4k
0
votes
1
answer
1k
views
IIS URL Rewrite from one domain to a different domain with Exact Match
I want to set up URL rewrite on IIS so when
https://oldurl.abc.com/portal/apps/#/myapp
was hit, it will redirect to
https://newurl.abc.com/myapp
I have tried the following, but it didn't work. any ...
- 560
1
vote
1
answer
548
views
Finding exact word in description column of DataFrame in Python
My list contains some words like : [‘orange’, ‘cool’, ‘app’....] and I want to output all these exact whole words (if available) from a description column in a DataFrame.
I have also attached a sample ...
- 293
1
vote
2
answers
109
views
Elasticsearch exact result not return on a first
I have added some products like 'lcd apple iphone 11' 'lcd apple iphone x' 'lcd apple iphone xs' 'lcd apple iphone xr' 'lcd samsung s8' 'lcd samsung s8+' 'lcd apple iphone xs max' 'lcd apple ...
- 145