Count Left from First charater

[james_halliwell]

Hi All,

Trolled the internet but didn't find anything that would help,

I would like to count the characters before the "-"

for example

12345678-1 (this would be a count of 8 as its 8 characters long taking off the -1

9876541-1 (this would be a count of 7 characters long taking off the -1)

Any advice would be greatly appreciated

 

[essaytee]

? instr("123-456","-")
 4

So for your example, then minus 1 from the result.

 

[james_halliwell]

? instr("123-456","-")
 4

So for your example, then minus 1 from the result.

Many thanks, I think I miss understood the MSN website

Appreciate you taking the time to help