Counting Characters

AppSheet AppSheet Q&A
1

Hi,

Would anyone know if there are any expressions that can help me count the amount of times a character appears in a cell?

For example:

I would like to count the amount of times a “/” appeared in the text below,

000123456/000257446/000344646

the answer would = 2

Thanks in advance,
Chris

2

You could combine SPLIT() and COUNT() to create a list and count the values. It gets a little tricky though because you have to test for the character being at the beginning or end.

1 Like
3

I would say… COUNT(SPLIT([Column],“/”))-1

2 Likes
4

@GreenFlux @Aleksi

Thanks guys, got the outcome required.

1 Like