Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives 3votes
5answers
183views
How to calculate percentage similarity between two comma-separated strings in Excel?
I'm trying to compare two comma-separated strings in Excel and calculate the percentage of similarity based on matching values at the same position.For example:Cell A2 contains: "1,E,E,E,E,E&...
1vote
1answer
116views
How to match a permission to an action in an Entra role using Powershell
From time to time, I am asked where a permission is being used in Entra. For example, who has access to modify network settings and on which resources? I have a script that does a pretty good job of ...
0votes
2answers
63views
How to allow a certain differences in a text assertion for a test case that has some expected changes in data using phpunit?
I am setting up a golden master test case, yet the result may be off at certain points due to side-effects changing some strings at known places.Getting rid of those side-effects would be best, yet ...
- 67.6k
2votes
1answer
257views
Fast Delphi ASM ASCII string comparison optionally ignoring first char
I am looking to create a Delphi function that ignores the first character of either string if it starts with a Chr(127). This is used in a sort comparison which is extremely slow with 30,000 items ...
- 323
0votes
0answers
25views
Comparing 2 strings of text from different rows showing the differences and what field the differences come from
I have a set of data and want to compare the differences between 2 rows but also label what column the differences appear.Type Units CostDogs. 5. £20Dogs. 5. £25...
-4votes
1answer
119views
String compareTo() in java
Consider:String s1 = "ABc";String s2 = "abc";System.out.println(s1.compareTo(s2));On which basis the output will be -32 if only the first character decimal value of s1 and s2 ...
0votes
0answers
28views
compare two blob colomn values to find percentage of similarity
how to compare two blob colomns on the same table ?For example: PIC1 contains a picture of a bridge taken from 5 meter distance, whereas PIC2 contains a picture of the same bridge taken from 10 meter ...
- 265
0votes
3answers
106views
VBA remove string custom salutation name from list table excel
I have string name with salutationDATIN SERI PADUKA JOHN DOE with actual name is JOHN DOEand i have list excel for salutation :DATIN SERIDATIN SERI PADUKACurrently using substitute function from ...
- 11
3votes
3answers
177views
Comparing alphabets but not using strcmp
I want to compare two strings with function int compare(char* A, char*B), returning 1 when A is larger, 0 when B is larger.Assume the maximum character is 100, I want the order to be ‘A’< ‘a’ < ...
1vote
5answers
151views
how to get rid of count if there is only a single character?
In my program, whenever I have a single character, it will have a count of 1. For example, if I had abbbbbc, I would get back a1b5c1. I don't want single characters to have a count. I like the program ...
-2votes
2answers
80views
PL/SQL function to detect a one way character change between 2 strings
I want to write a PL/SQL function with 4 arguments: SEARCH_STRING, CHECK_STRING, SEARCH_CHAR and CHECK_CHARwhere the function will check the SEARCH_STRING against the CHECK_STRING and detect whether ...
2votes
1answer
54views
Why is CompareTo() not recommended for checking equality?
I was reading about best practices for comparing strings and saw these two points:Use the String.Compare and String.CompareTo methods to sort strings, not to check for equality.Don't use an ...
- 10.2k
-1votes
1answer
95views
Seeking an algorithm or approach to compare values between two strings (.NET)
I have a problem with a piece of data as a string, and I have to check if the data exists between the stated ranges.Note that if both ends are numbers, the comparison is not the usual number ...
- 1,724
0votes
1answer
64views
Unable to understand the difference between normal comparison of strings and comparison using localCompare() method as both works differently
I am a newbie in JavaScript and programming. Need assistance to clarify this doubtconsole.log('a'>'A'); // -> Truelet result = 'a'.localeCompare('A'); console.log(result); // -&...
0votes
1answer
72views
Option Compare Text in VB.net is *very* slow?
I only learned of Option Compare Text recently so I wrote a little test:Dim sw As New Stopwatch()Dim w As Boolean = Falsesw.Reset()sw.Start()Dim A As String = "hello, world"For o As ...
- 9,344
- The Overflow Blog
- Featured on Meta
Hot Network Questions
- Software serial and RS485
- Is there a term for the sound the orchestra produces when they tune?
- Are the lampstands the same in Rev 11 and Zec 4?
- Old movie about the child Jesus, who is seeing his own future as he walks through Jerusalem
- Single point in a figure on beamer
- Eel-wielding man drowns and his enemy leaves town
- Can a chocolate bar contain alcohol naturally?
- What are the correct lyrics to the song "Lola", by The Kinks?
- Spectraly extremal connected trees, a conjecture on majorisation of Laplacian eigenvalues
- Define Min and Max Values in Geometry Nodes Relatively to Another Mesh
- The Worst Possible Chess Move
- Any concerns using blown-in cellulose without blower in a small cavity between cathedral ceiling and roof?
- Creating a spiral
- What physical changes to the mouth would cause problems with articulation?
- How to use an iPad as an external monitor with Mac mini 6.1 (Late 2012) for installing Ubuntu?
- MinMaxStack - tracks minimum and maximum values
- Extreme outlier in real data
- stim: why would order of CNOT operations affect detectors
- How to flip or mirror keyframes horizontally on the X-axis in Graph Editor?
- Why does LaTeX put the PDF tags for floats at the end of the document?
- Visualizing Different Coordinate Representations of Complex Numbers
- Why does JavaScript use autoboxing?
- Dual nationality citizen registering for EES in Switzerland
- Proverb for when one is already in a hurry but the condition wastes even more time