convert function to strip out comma character
Posted: Thu Jun 17, 2010 2:59 pm
Hi,
I am using a following syntax to repalce comma character and then if I find any "!" in my string I want to set it to NULL to avoid using those values.
However I still see output column values with comma in it.
var1 = Convert("#$%/&,;","!!!!!!!", SvDomain)
and using a following constraint to set it to null Index(var1, "!",1) >0
thank you,
Kiran
I am using a following syntax to repalce comma character and then if I find any "!" in my string I want to set it to NULL to avoid using those values.
However I still see output column values with comma in it.
var1 = Convert("#$%/&,;","!!!!!!!", SvDomain)
and using a following constraint to set it to null Index(var1, "!",1) >0
thank you,
Kiran