Using Text.Position, but don't understand the result I'm getting back

Hi,
I've been trying to use 'Text.PositionOf' to count the occurance of commas , but I don't I don't see what's happening,

< Table.AddColumn(Source, "TextPosition", each Text.PositionOf([Category],",",Occurrence.All)) >


I get a list back but it doesn't return what I would expect ie if the the first comma is the second character then '1'
if the second is the 5th then '4'.


but for the the sequence ; a , a , b , c , d results in ; i get a list ; 2,6,10,14

I have looked at the Microsoft DOCS for M but didn't find it much help.

Please find very small workbook attached.

Richard.

Sorry I'm not with you? I know pq counts from zero, so surely in: a , a , b , c , d , the first comma is in the second position, so '1',
the second comma is in the 4th position so '3' the 5 and 7?
Really confused. Oh, I have to go out so if you reply , I won't be able to respond until tomorrow, not ignoring you.

Richard.

Yes,
Thanks, the penny did finally drop after I'd messaged you.
I'll mark this closed and thanks for the help.

Richard.