Can not count Japanese charactor by LEN()

AppSheet AppSheet Q&A
1

Hello.

Is it possible to count full-width Japanese characters?

The app has a column where Japanese is entered, and LEN () is used in the Vald_if expression, but both full-width and half-width characters are counted as one character.
This field is converted to PDF using a print template, but I need to limit the number of characters so that the template doesn’t collapse during user input.

1 Like
2

@Emily

I have almost the same question :sweat_smile:

I want to regulate a text box byte number under 50 but I can’t find any expression which can count byte of character; LEN(), FIND(), etc. counts both single and multi character as 1.

Probably this LENB() espression in google spreadsheet will help us?

https://www.googlecloudcommunity.com/gc/Feature-Ideas/Introduction-of-LENB-Expression/idi-p/388135

1 Like