Replace null field in record with double pipe
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Wed Jul 18, 2007 12:23 am
- Location: Chennai
Replace null with double pipes
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
Is there any way to implement this? As there are lots of coulmns involved.
Thanks again.
Prasad
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:
Yes, for every column.
Code: Select all
If IsNull(Link.Field) Then '||' Else Link.Field
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers