'Google sheets: Count Specific Characters in a string of words
I have on Google sheets this data (It is the same principle in excel).
I want to count the numbers of dose in each strings.
I use this formula and it return me this:
=LEN(L3)-LEN(SUBSTITUTE(L3,"/",""))
Product | dose | Count "/" |
---|---|---|
1 | 0 | |
2 | 5G | 0 |
3 | 10G/20G/24g | 2 |
I would like instead in returns me this :
Product | dose | Count "/" |
---|---|---|
1 | ||
2 | 5G | 1 |
3 | 10G/20G/24g | 2 |
How I can modify my formula to return me this?
Solution 1:[1]
In C2
:
=ARRAYFORMULA(IF(LEN(B2:B),LEN(B2:B)-LEN(SUBSTITUTE(B2:B,"/",""))+1,""))
Or:
=ARRAYFORMULA(IF(LEN(B2:B),LEN(REGEXREPLACE(B2:B,"[^/]",""))+1,""))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 |