SCAN Function for Special Characters

[mce]

Hi,

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

Code: Select all

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

[Steve Rowe]

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

HTH

[mce]

I found my mistake. Here is the correct one.

Code: Select all

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