Introduction of LENB Expression

For those who are using AppSheet with languages other than English, it is pretty much useful if we could get the same function as Google Spreadsheet/Excel of LENB()

https://support.google.com/docs/answer/9367584?hl=en&ref_topic=3105625

With this expression, we can validate the user's data input with validif expresion in various ways.

(We could control the data entry must be always 全角・半角)

 

@takuya_miyai 

@Kirk_Masden 

Status Open
7 2 152
2 Comments
Kirk_Masden
Gold 1
Gold 1

Yes!  I have used LENB() as well in Google Sheets.  If one is counting the number of letters in text, this becomes useful, as @Koichi_Tsuji wrote, if one is dealing with the Japanese language.

Kawano164
Bronze 5
Bronze 5

Yeah, I want it too.

FINDB(),LEFTB(),RIGHTB() as well. In multi byte character language, only LEN() is not enough for controlling character.