Counting items in a cell

[aurelie_toussaint]

I have imported an excel table into Alteryx for further use in Tableau. I need to count the number of items (delimited by ; ) in a cell. How can I do this?

Thank you!

[AdamR_AYX · Accepted solution]

If you just need a count then I think this formula will give you that

REGEX_CountMatches([Field1], ";") + 1

If you actually wanted to split the items into individual cells then I'd take look at the "Text To Columns" tool in "Split to Rows" mode.

Cheers
Adam

[aurelie_toussaint]

Thanks!