DSXchange

Hi,

Any of my tries are not working.

Please help me how to check whether it is null or not for a string field.

I tried out with IsNull(),SrcInput field="",trim and all.

Please reply me ASAP

Hi Ray,

Anyway the null handling with trim function is throwing one compilation error.

Please correct if my idea goes wrong.

I think, it can be done setNull() function.

Hi,

The datatype for the field is varchar.

I wrote the below line of code.

If IsNull(Trim(DSLink14.address2," ")) Then DSLink14.address3 Else DSLink14.address2

Hi sanjeev,

I tried with your logic, but it's throwing one compilation error.

It seems that all the logic seems to be fine for me.

I wrote this line of code over there.

If IsNull(Trim(DSLink14.address2)) Then DSLink14.address3 Else DSLink14.address2

any comments/Suggestions appreciated.

Hi everybody. Please help me to get out of this problem. I have 3 address fileds in my file. In that , what I need to do is , if the value of address1 is null then address2 value need to be moved to address1 and accordingly address3 value need to be moved to address2. This should be done for all the...