topic Re: How can count the number of characters in a cell? in Discussions

How can count the number of characters in a cell?

lala — Fri, 09 Jun 2023 22:01:48 GMT

For example, how to count the number of line names with the first character of the name?

Thanks!

jthi — Mon, 28 Dec 2020 09:52:37 GMT

If I understand correctly what you want to do (calculate character count for the first character in name) you could do it with something like this:

Get length of the name -> Length(:name)
Remove first character from the name -> Substitute(:name, Left(:name, 1), "")
Get length of the string where first character is removed -> Length(previous part)
And finally calculate difference between these two strings

Length(:name) - Length(Substitute(:name, Left(:name, 1), ""))

Craige_Hales — Mon, 28 Dec 2020 12:05:26 GMT

Clever! (And comment your code if you use this, the next person will appreciate explaining what you are doing!)