count frequency of specific character in a string

[Anonymous]

Firstly: this question probably sounds similar to this one.

But that query could not answer my question as far as I could tell. 

I have a table which uses a projectCode column to establish whether a given record is a parent, child or subchild. 

Parent entries are denoted as a number, eg 6. 

Child entries are denoted as a number, a comma and then another number. Eg 6,8. 

Subchild entries follow this theme, with 2 commas. Eg 6,8,3. 

It would be useful for me to use 'number of commas in projectCode' logic to establish whether a given item is a parent, child or subchild in powerapps, but I can't figure out how to do this. Ideas? Thanks!

[mdevaney · Accepted solution]

@Anonymous 

My suggestion would be to use SPLIT to change the Text data into a single column table and then COUNTA the rows.

CountA(Split(TextInput1.Text,","))-1

It just so happens I responded to a similar question last night so the code was still available in my forum testing app.

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Replacing-a-string-with-mutiple-commas-by-a-single-comma-using/m-p/407092#M119751

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Anonymous · Accepted solution]

Perfect-thank you!

[mdevaney]

@Anonymous 

No problem at all.  If my post solved your issue please mark it as the Solution to close the thread.

[Anonymous]

Unfortunately I had to re-upload the (static excel) data this afternoon and now each 'split' function is presenting an 'invalid argument' error. I tried formatting all ID_numbers as text in excel but this did not solve the issue. And using text() to wrap the function like below simply meant that the split() function was ignored/not executed:

CountA(Split(Text(TextInput1.Text),","))-1

Also, entering '.text' at the end of textInput1 in your example did not make it a valid argument type. This is just a column of plain text values...do you know what's going on? Thanks.