I have a short text field with a record containing the text ‘Açaí Bowl.png’
I have another formula field that strips the file extension from text in this field, but instead of the expected result of ‘Açaí Bowl’, I get ‘Açaí Bong’. :smiling_face_with_halo: Somehow the last two characters of ‘Bowl’ are transforming?
Here is my formula text, which usually works fine:
No, it does not behave the same way in my base. In my base I get the expected result.
However, it may be that the accented character is being encoded differently for you. Accented characters are sometimes stored under the hood as multiple characters, which may be affecting the way the RIGHT formula is dealing with the length. Notice that the formula is still removing four characters (wl.p), just not the characters you want.