Stack Overflow
Stack Overflow

Questions tagged [exact-match]

208 questions
1
vote
2 answers

How to make FIND function exact in Excel

I'm using the FIND function in Excel to check whether certain characters appear in a string of characters in a cell. However, this function doesn't work cleanly for certain special characters. Specifically F̌,B̌, and some others. When F̌ appears in…
Tantomile02
  • 13
  • 3
1
vote
2 answers

Search by exact match in all fields in Elasticsearch

Let's say I have 3 documents, each of them only contains one field (but let's imagine that there are more, and we need to search through all fields). Field value is "first second" Field value is "second first" Field value is "first second…
Roman Puchkovskiy
  • 11,415
  • 5
  • 36
  • 72
1
vote
2 answers

grep exact match of string with alphabets and numbers

I am using grep to extract lines from file 1 that matches with string in file2. The string in file 2 has both alphabets and numbers. eg; MSTRG.18691.1 MSTRG.18801.1 I used sed to write word boundaries for all the strings in the file 2. file…
Kousalya Devi
  • 13
  • 4
1
vote
5 answers

How can I find the exact value using xpath in selenium webdriver for text that contains  ?

I'm having an issue selecting the exact text 'Section' from the code using xpath. ** To be clear I require the exact text selection to be made from the innerText or innerHTML of the element if that is possible, not the id. ** I'm able to use the…
Redflame
  • 21
  • 1
  • 7
1
vote
4 answers

Matching exact strings in python

How can I match exact strings in Python which can dynamically catch/ignore the following cases? If I want to get value2 in this IE output "Y" from a file that is formatted as such: ... --value1 X ---value2 Y ----value3 Z .... How can I search for…
cc6g11
  • 477
  • 2
  • 10
  • 24
1
vote
3 answers

Vlookup with Exact match

I am trying to do Exact match using Vlookup but it is not working with this formula. IF(EXACT(A4,VLOOKUP(A4,'names'B:B,1,FALSE))=TRUE,VLOOKUP(A4,'names'B:B,2,FALSE),"False") I have a tab which looks like this: I have one more tab with in same…
TA Arjun
  • 25
  • 4
1
vote
1 answer

SQL Server: update to match and replace only exact words

I want to match an exact word and replace it with another word. Here is the SQL Server query that I am using: UPDATE BODYCONTENT SET BODY = CAST(REPLACE(CAST(BODY AS NVARCHAR(MAX)), 'Test' , 'prod') AS NTEXT) WHERE BODY COLLATE…
Ilak
  • 158
  • 3
  • 13
1
vote
3 answers

How to get the latest value of one filed(Django Model.objects.filter())

I have models as below: class ProjectRecord(models.Model): user = models.ForeignKey(User,on_delete=models.CASCADE, null=True, blank=True,related_name='user_projects') project = models.ForeignKey(Project,on_delete=models.CASCADE, null=True,…
Elsa
  • 1
  • 1
  • 8
  • 27
1
vote
0 answers

Similar String Matching Algorithm : Jaccard, Dice ,Cosine and Exact

I am trying to find out the similarity between two english sentences. Among Jaccard, Dice, Exact and Cosine string matching algorithm which is the best when it comes to string matching or determining the closeness? Sentence 1: Online shopping for…
Hassan Anwer
  • 347
  • 2
  • 14
1
vote
1 answer

Fast FullText search for one occurrence of exact phrase in MySQL sorted by id

I'm using MySQL/InnoDb. I have this table News which has about 3,000,000 records and I hope it gets 7,000,000 more. Currently I use the following query to fetch records from News table with exact phrase inside their title or content: SELECT * FROM…
mrmowji
  • 934
  • 8
  • 29
1
vote
2 answers

Merge two tables exact and fuzzy

I have two tables that I would like to merge based on an exact match on one variable and a fuzzy match on another. Consider the two tables below. For each id1 in dt1, I would like to find an id2 in dt2 that matches exactly on size and where the…
user1389960
  • 433
  • 4
  • 11
1
vote
2 answers

How do I get an exact / whole word only match in fullText from DriveApp.searchFiles in Google Apps script

I want to search file contents in Google Drive for files that contain the word 'pass' - an exact match on the whole word 'pass'. Currently I am using the following call: var files = DriveApp.searchFiles('fullText contains \'pass\''); I tried with…
Richard McKechnie
  • 2,748
  • 1
  • 15
  • 13
1
vote
1 answer

Find all rows with the same exact relations as provided in another table

Given these tables: Table: Test Columns: testID int PK name nvarchar(128) UNIQUE NOT NULL Table: [Test-Inputs] Columns inputsTableName nvarchar(128) UNIQUE PK testID int PK FK Temporary Table: ##TestSearchParams Columns: inputsTableName…
DeceitfulEcho
  • 71
  • 4
  • 14
1
vote
3 answers

Exact replace of string in Javascript

hidValue="javaScript:java"; replaceStr = "java"; resultStr=hidValue.replace("/\b"+replaceStr+"\b/gi",""); resultStr still contains "javaScript:java" The above code is not replacing the exact string java. But when I change the code and directly pass…
Gopi
  • 5,656
  • 22
  • 80
  • 146
1
vote
2 answers

Error in calculating exact nearest neighbors in radius with FLANN

I am trying to find the exact number of neighbour nodes in a big 3D points dataset. The goal is for each point of the dataset to retrieve all the possible neighbours in a region with a given radius. FLANN ensures that for lower dimensional data can…
Constantino Mood
  • 21
  • 4
1 2 3
…
13 14