TM1 Forum

Posted: **Fri Nov 26, 2010 9:39 am**

Hi,

When I use SCAN function to find character : in a text, it does not work.

vFuncID = SUBST(vElement,1,SCAN(vElement,':')-1);

Is there anything wring with this? or is there a special way of using SCAN for special characters?

Any help would be apprecicated.

Regards

Posted: **Fri Nov 26, 2010 10:04 am**

If you are sure the : exists in vElement then perhaps try putting the ~ infront of the :

HTH

Posted: **Fri Nov 26, 2010 10:14 am**

I found my mistake. Here is the correct one.

vFuncID = SUBST(vElement,1,SCAN(':',vElement)-1);

SCAN Function for Special Characters