Creating of Routine fr this Function nt to allow Special Chr

[John Daniel]

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

[Sainath.Srinivasan]

Why a routine and not a transform ?

You can make it into routine as

Code: Select all

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