By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| strings | (No column name) | (No column name) | (No column name) | (No column name) |
|---|---|---|---|---|
| cat;dog;;horse;;;fish; | 1 | 4 | 3 | cat |
| cat;dog;;horse;;;fish; | 5 | 8 | 3 | dog |
| cat;dog;;horse;;;fish; | 9 | 9 | 0 | |
| cat;dog;;horse;;;fish; | 10 | 15 | 5 | horse |
| cat;dog;;horse;;;fish; | 16 | 16 | 0 | |
| cat;dog;;horse;;;fish; | 17 | 17 | 0 | |
| cat;dog;;horse;;;fish; | 18 | 22 | 4 | fish |
| cat;dog;;horse;;;fish; | 23 | 23 | 0 |