Replace null field in record with double pipe

[chulett]

If you are writing to a pipe delimited file, then what you want to happen will happen automatically. What issue are you having?

[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

[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.