Page 1 of 1
Posted: Tue Oct 21, 2008 6:50 am
by chulett
If you are writing to a pipe delimited file, then what you want to happen will happen automatically. What issue are you having?
Replace null with double pipes
Posted: Tue Oct 21, 2008 7:01 am
by prasad_chennai
Sorry for the typing error Chulett. Actually I want to replace the null field with a double pipe. And I want to implement this in my transformer.
Is there any way to implement this? As there are lots of coulmns involved.
Thanks again.
Prasad
Posted: Tue Oct 21, 2008 7:06 am
by chulett
Still confused, but if that's really what you want to do simply use the IsNull() function to check and if true then replace the value with two pipes:
Code: Select all
If IsNull(Link.Field) Then '||' Else Link.Field
Yes, for every column.