I noticed that every text returned by OCRTEXT always has a comma (, ) at the end of it (such as "Hello, ").
I have a column (named OCR) for receiving OCRTEXT([Photo]). I also have another column to get the text from the OCR column by putting expression in the INITIAL VALUE.
CASE 1: This expression is working fine:: UPPER([OCR]) ::returns HELLO,
CASE 2: This expression is working fine:: FIND(",", "12, ") ::returns 3
CASE 3: This expression is not working as expected:: FIND(",", [OCR]) ::returns 0 (zero) instead of 6
AppSheet does not recognize the comma in the CASE 3, why?