Remove Box character

sagar deshmukh · Post by **sagar deshmukh** » Tue Feb 08, 2011 4:01 am

Hi,

I have a job where I am pulling data from VSAM using ODBC then trasformer and then finally loading into Teradata DB.

for one of the column i am getting BOX character, In hex editor the value of BOX character is 20.

I tried below functions, but nothing is working for me please help me out.

function tried : Convert(CHAR(13),"",YourField)

Thanks
Sagar.

Sreenivasulu · Post by **Sreenivasulu** » Tue Feb 08, 2011 6:29 am

Convert from ebcidic to dos (ie. the equivalent of unixtodos command')

Regards
Sreeni

sagar deshmukh · Post by **sagar deshmukh** » Tue Feb 08, 2011 6:31 am

Hi, I am really sorry , I am not aware of this..How to do this?

chulett · Post by **chulett** » Tue Feb 08, 2011 8:43 am

If it is a "20" why did you use "13" in the Convert? And that "box" is a 20 in decimal? Hex? For the former use CHAR(20), the latter CHAR(32).

sagar deshmukh · Post by **sagar deshmukh** » Tue Feb 08, 2011 8:58 am

sorry for the 20 previously mentioned..just downloaded another hex editor here its showing 00..this is the hex value

chulett · Post by **chulett** » Tue Feb 08, 2011 9:00 am

OK... so what are you going to try next?

sagar deshmukh · Post by **sagar deshmukh** » Tue Feb 08, 2011 9:07 am

convert(char(00),"", ABCD)

This is working, thanks for your help.