DSXchange

Posted: **Mon Oct 25, 2010 1:01 am**

Hi,

How to create the routine for this function not to allow the special characters.

Function :

Convert(Convert('ABCDEFGHIJKLMNOPQRSTUVWXZY0123456789','',YourField),'',YourField)

What could be the Code to create the routine for this function ??

Thanks,
John

Posted: **Mon Oct 25, 2010 5:18 am**

Why a routine and not a transform ?

You can make it into routine as

Code: Select all

Ans = Convert(Convert('ABCDEFGHIJKLMNOPQRSTUVWXZY0123456789','',Arg1),'',Arg1)

DSXchange

Creating of Routine fr this Function nt to allow Special Chr

Creating of Routine fr this Function nt to allow Special Chr