This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am comparing two string fields in a Filter tool and getting unexpected results.
When I use the Filter tool to compare two strings with values of "Extendicare Fort MacLeod" and "Extendicare Fort Macleod" (note the lowercase "L" in the second), the tool returns these as being equal. i.e. [FAC_NAME]==[FAC_NAME_BAD] returns true.
How do I do a string comparison that is Case Sensitive?
Please mark @NicoleJohnson as a solution for this post. Her solution is FASTER than mine. I tested hers with 1,000,000 records and RegEx completes the comparison filter in less than 1 second. The conversion to the MD5 hash and evaluation takes roughly 8 seconds.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
I don't think this will work in the more general case. As regex special characters will cause problems for example '(',')' Since they won't be escaped in a standard string. I think the ASCll Solution is more robust.