Questions tagged [exact-match]
208 questions
1
vote
2 answers
How to ensure that a figure is true if format of both cells are different in Excel?
Screenshot of my problem
When I use the exact formula to ensure that two figures matches in Ms Excel 2010 the answer gets false.This is because the two cells I am matching are of different formats.You can refer to the screenshot.

Umar
- 9
- 2
1
vote
1 answer
Exact match in elastic search
I have indexed large pdf files into elastic search engine. I have analyzed this Unstructured Data with a snowball analyzer. this converts words like "running" to "run" using the snowball filter. but what if I want to search exactly for word…

ravinder reddy
- 309
- 1
- 4
- 17
1
vote
4 answers
Perl regex multiline match without dot
There are numerous questions on how to do a multiline regex in Perl. Most of them mention the s switch that makes a dot match a newline. However, I want to match an exact phrase (so, not a pattern) and I don't know where the newlines will be. So the…

Marijn
- 1,640
- 14
- 24
1
vote
3 answers
Exact match for string using XPath
I wrote an xpath to scrape elements from a web page using selenium c#.
Here is the XPath
tbody/tr[@backcolor]/td/b/a[contains(text(),"match text")]
This is working fine until I found duplicates coming for match text. So, on a web page I've two…

Karthik Chintala
- 5,465
- 5
- 30
- 60
1
vote
1 answer
PHP exact match between input and regex pattern
I'm trying to build a check that reliably evaluates whether the input ($f_username) is a MAC Address via Regex 'cause there are different Syntax it could take. Upon finding a match. this should be transferred to lowercase without deliminators.
The…

Felix Joel
- 75
- 1
- 8
1
vote
1 answer
how extract exact match from a file without grep -w
I have a file A with one colum with a list of strings like this:
12
123
1234
1234567
I want to use the strings in file A to grep the lines that contains them in file B, and file B looks like this:
1 0/0 ./. 0/1 0/0
12 0/0 …

user2820398
- 63
- 1
- 1
- 5
1
vote
1 answer
Discrepancy between results of EXACT function and Conditional Formatting
I'm observing an apparent discrepancy between the results of the EXACT function and the conditional formatting tool.
Two cells in Column B have the same apparent text (about 30-40 words). But the "highlight cells" tool doesn't recognize them as…

Tupelo Thistlehead
- 143
- 5
1
vote
3 answers
Regex to check if exact string exists
I am looking for a way to check if an exact string match exists in another string using Regex or any better method suggested. I understand that you tell regex to match a space or any other non-word character at the beginning or end of a string.…

Jayrox
- 4,335
- 4
- 40
- 43
1
vote
2 answers
Excel - Search an exact match within a string
I'm currently struggling on finding the formula that will resolve my problem.
Here's the status quo:
In Sheet 1, column A, I have a set of string, such…

BigBadBaptiste
- 19
- 6
1
vote
2 answers
Exact string negation in javascript regexpressions
This is more a question to satisfy my curiosity than a real need for help, but I will appreciate your help equally as it is driving me nuts.
I am trying to negate an exact string using Javascript regular expressions, the idea is to exclude URL that…

runlevel0
- 2,715
- 2
- 24
- 31
1
vote
1 answer
Copying One column from table to another table that has matching variables in another column
I hope I can explain this to make sense lol.
I am trying to copy variables from one hats_old.red to hats_new.red that match hats_new.name in both tables, if they do not match then i need it to do nothing so it does not null the value or set it to…

conFIGuredAPK
- 33
- 3
1
vote
2 answers
RegEx exact match ^abc$ doesn't work
I am trying to use regular expressions in JavaScript to test if the value of a form text input is a French mobile phone number.
French mobile phone numbers begin with 06 or 07 and are followed by 8 digits, like these : 0611223344 or 0744332211. The…

Seeven
- 969
- 1
- 8
- 24
1
vote
1 answer
In Scheme how can I split an exact (rational) number into dividend and divisor?
The function I am looking for is something like:
(split 1/3) => (1 . 3)
(split 1093/209) => (1093 . 209)
Is it possible in RnRS, SRFI or any custom implementation?

Felipe
- 16,649
- 11
- 68
- 92
1
vote
1 answer
Perl regex.. match words exactly 2 times...Input is a JSON file
I am a beginner for any sort of regex. I need your help/pointers in resolving an issue. I have a JSON file which looks like this below.
JSON…

spamulap12
- 97
- 1
- 9
1
vote
1 answer
Solr - Match whole word only in text fields
I have a text field that can contain very long values (like text files).
I want to create field type for it (text, not string), in order to have something like "Match whole word only" in notepad++, but the delimiter should not be only white…

axelrod
- 3,782
- 1
- 20
- 25