Property Set VB script code doesn't return value

[jobin.e]

Hi, 

I have a property set definition that has a value lets say 8605-GF-743-8.05-SQ-FSSS-081

I need to create 7 formula based property that returns the values separated by the underscore

for eg 1st property definition will return 8605, second will return GF and so on...

I created another formula based property definition that uses the mid function to return a portion of the string (see attached image).

But it doesn't return the desired value. Can anyone tell me what I'm doing wrong?

Regards

Jo

[jobin.e · Accepted solution]

Never Mind.

Got it solved. Working code below.