How to convert a comma separated text field from a column to count column of text field across rows

[Anonymous]

Hi 

I have a cuisines table having columns as below

Column Name : Cuisines

Row Values : (European,Arabian,Japanese,Bakery,Desserst)

I wan result in Another column like 

Cuisines                                                               -                 Count of Cuisines

European,Arabian,Japanese,Bakery,Desserst      -                        5

How can i get this results.

Can any one help me regarding this..?

Thanks in advance...

[FreemanZ · Accepted solution]

hi @Anonymous 

try to add a calculated column like:

Count = 
LEN([Cuisines - Copy])
-
LEN( SUBSTITUTE([Cuisines - Copy], ",", ""))
+1

it worked like:

[Anonymous · Accepted solution]

Thank you @FreemanZ  Got it

[FreemanZ · Accepted solution]

yes, my pleasure

1) the count of cuisine is count of comma+1

2) replacing comma with blank("") makes the list short. The shortage is the count of comma.

make sense?

[Ahmedx · Accepted solution]

also possible like this

=PATHLENGTH(SUBSTITUTE([Cuisines - Copy],",","|"))

[Anonymous · Accepted solution]

Thank you @FreemanZ  Got it

[Anonymous]

Hi @FreemanZ  Can you share detailed expalantion for understanding purpose..

[FreemanZ · Accepted solution]

yes, my pleasure

1) the count of cuisine is count of comma+1

2) replacing comma with blank("") makes the list short. The shortage is the count of comma.

make sense?

[FreemanZ · Accepted solution]

hi @Anonymous 

try to add a calculated column like:

Count = 
LEN([Cuisines - Copy])
-
LEN( SUBSTITUTE([Cuisines - Copy], ",", ""))
+1

it worked like: