both the strings in the image are equal but on comparision it is returning false.
below is the string
431110-M-PID-01-002-01
That is weird. Maybe try comparing character-by-character to determine where it doesn't match. Something like this:
with '431110-M-PID-01-002-01' as x, '431110-M-PID-01-002-01' as y
unwind range(0,size(x)-1) as i
with substring(x, i, 1) as a, substring(y, i, 1) as b
return a, b, a=b
i tried comparing character by character but it is not working.. at some character "I" equality is false
Is it possible that one is a lower case “L” and the other an upper case “i”?
You could try using an apoc method to convert each to the hex code to see if they are different.
with '431110-M-PID-01-002-01' as x, '431110-M-PID-01-002-01' as y
unwind range(0,size(x)-1) as i
return apoc.text.hexCharAt(x, i), apoc.text.hexCharAt(y, i)
You could also compare each as lowercase.
with '431110-M-PID-01-002-01' as x, '431110-M-PID-01-002-01' as y
with toLower(x) as a, toLower(y) as b
return a, b, a=b