Bridge - Limit Amount of Characters in a String

jokano1

I am trying to limit the amount of Characters in a String to Less then 50. So if there is more than 50 characters I want to remove the excess Characters, is this possible? I built out checking the size of the string and substracting the 50 from that amount, but I cannot find a way to remove that many characters from the String. Is there a way to do this?

Screenshot 2022-06-08 105247.png

Mike TV

@jokano1

=LEFT([Column2]@row, 49)

This will change the value in the column/row you point it to so that it's just 49 characters.

Example of it working: