• This doesn't work for what I am wanting, it is counting the spaces, It doesn't count the characters before the spaces, as you see in the data below for 5...It should be 3 for the first set of 5's and 2 for the 2nd set of 5's. I am not sure what this is doing with the numbers, instead of a comma I changed to (' ') a space.

    5555 55 1NULL

    5555 55 2NULL

    65 5555 hhh1NULL

    65 5555 hhh2NULL

    65 5555 hhh3NULL

    85555 5 lll 1NULL

    85555 5 lll 2NULL

    85555 5 lll 3NULL

    955555 1 k1NULL

    955555 1 k2NULL

    955555 1 k3NULL

    101888 555 jjj551NULL

    101888 555 jjj552NULL

    101888 555 jjj553NULL