convert function to strip out comma character

[mkkgupta]

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

[anbu]

Isolate the rows in target which has comma and look for the same rows in input and check for any non-printable characters

[mkkgupta]

I do not see any spl characters.

here is the example

PLAINSISD,ESC17.NET

[ray.wurlod]

Capture the value of var1 and svDomain, perhaps using an in-link Peek stage - what's in them for the rows where a comma still gets through?

[mkkgupta]

I did not gave value for length filed while calculating SvDomain Stg. variable using substring function.

issue is resolved as soon as i provide length in substring.

I saw only records related to "comma" made me to post this topic.

Anyway thank you All!!!

Kiran