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!