EX case sensitivity
While searching for data through the API I realized that the EX query is case sensitive. In my specific table, this returns nothing:
"{'6'.EX.'JOHN DAVIS LLC'}"
while this returns a r...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe low tech way would be to create a new field called [Company Upper Case] with a formula of
Upper([Company])
Then the .EX. will work as everything will be in upper case. That Upper function does not change numbers or special characters so it's safe.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Upper([Company])
Then the .EX. will work as everything will be in upper case. That Upper function does not change numbers or special characters so it's safe.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
I think you can use CT (contains) instead of EX (exactly) as well.
------------------------------
Jeff Peterson
------------------------------
------------------------------
Jeff Peterson
------------------------------