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…
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…
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…
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…
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