Loading csv , Last Column, String Function (Trim/Left)

[imfarhan]

Hi All,

I have a small csv file, It loading successfully into my target table.
However, the last column which keeps only flag values "Yes" or "No" and some are nulls

When I look into target Table (DB2) it show like: No□ Yes□
Those square boxes showing don't know why?
I thought no carriage return at the end of the row but I tried still showing

Please advise?

I tried to tacke using Trim (Field, " ","A") or TRim(Field,"","T") or Trim(Field)

Regards
Farhan

[imfarhan]

Found the function

Code: Select all

Left(Field,Len(Field)-1)

Thanks for the help
Regards
F

[chulett]

Do you understand why your Trim examples didn't work?

[chandra.shekhar@tcs.com]

If I were you, I will never do that untill I find out the exact cause for it.
Just manipulating your data according to your need is not a correct practice.
First you need to find out that why the square boxes were showing up in your data ? Was it due to the file or due to datatype(CHAR) ?
E.g If you get Yes as one of the incoming value then according to your formula Ye will go to the target.
As a good datastage developer try to think from a broader perspect, then only after finding the root cause, build your logic.

[imfarhan]

I've a feeling its becaue last column and its carriage return may be.
Do you thik I can handle this problem using field properties of my SEQUENTIAL load file under the "Edit-Column-Metadata" field properties?

May be I can handle throught Delimiter properties. I will try if its work I will take off the function . thanks for your input and suggestions

Regards
Farhan