Hi,

I'm using Zoho Analytics to investigate some formatting issues we've come across in our Deals from Zoho CRM and it seems that something's wrong with some of our records.

Although we defined a global set to pick from in our "Lead Channel" picklist, comparing this table's column to 'field representative' returns False.

I took a closer a look at these table rows and added a column to represent their length. The expected value for that would be 5 (FIELD) + 1 (white space) + 14 (RE PRE SEN TA TI VE) = 20, but I'm getting 22 and I realised these 2 extra characters are not white spaces, since I added the REPLACE function for being able to see what's invisible.

I was not able to find any REGEX replace method for Query tables in Zoho Analytics, are there any other resources I could use to find what the problem is?

Finally, I should mention that I tried to export my Query Table as CSV and I could not find any weird characters in the "Lead Channel" column, so I'm basically clueless of what's going on.

Please take a look at all the screenshots attached. They illustrate how my query and its result look like.

Hoping for some help,

Arthur