This is a dimension, I want to separate the data by ' 、' and then I could count the number of names for each row.
Now I have no idea for this problem.
Any advice or insight would be appreciated greatly. ^_^
4 answers
For each row, do you want to know the total number of names or do you need to see it broken down by Name?
If it's just the total number of names, you could calculate this based on how many times your separator character appears.
We can do this by taking the length of the string and subtracting the length of the string with the separators removed.
I.e.
ABC~DEF~G = 9 characters
ABCDEFG = 7 characters
9 - 7 + 1 = 3 separated strings.
If you need to break out the count of individual names, things get a bit tricky...
