how to remove box character insequential file

sagar deshmukh · Post by **sagar deshmukh** » Fri Dec 12, 2008 7:39 am

i am reading a cvs file into a sequential file. but i am getting box character in the output.please let me know if i need to apply any setting for this. :idea:

chulett · Post by **chulett** » Fri Dec 12, 2008 7:41 am

First step would be to determine exactly what this "box character" is, typically by checking with a hex editor to get the hex/octal value, many of which are free downloads.

sagar deshmukh · Post by **sagar deshmukh** » Fri Dec 12, 2008 7:45 am

i belive because of space the box character is comming just need to know the solution how to remove that

chulett · Post by **chulett** » Fri Dec 12, 2008 7:51 am

You need to know what the character is before you can remove or otherwise handle it properly. And do not use private email to ask for help when people here are obviously trying to do exactly that.

sagar deshmukh · Post by **sagar deshmukh** » Fri Dec 12, 2008 7:53 am

i dont have premium membership so i cant read ur post thats y i asked to end it on my mail ID

chulett · Post by **chulett** » Fri Dec 12, 2008 7:57 am

You can see everything I posted.

sagar deshmukh · Post by **sagar deshmukh** » Fri Dec 12, 2008 8:01 am

chulett · Post by **chulett** » Fri Dec 12, 2008 8:17 am

Good Lord. YES, you can.

Regardless, you need to let us know what the actual value of the "box" is, then people can help. Maybe saying it three times will be the charm.

dslisa · Post by **dslisa** » Fri Dec 12, 2008 8:50 am

Hi, sorry to post in an open post but I have the exact same issue and the Hex character is '0D'.

Job design..

Database----------->Xfm----------------->seqfile

The database gets populated with mainframe file and the hex character is coming from that mainframe file. I do not have control over how the file gets populated to the database.

dslisa · Post by **dslisa** » Fri Dec 12, 2008 8:51 am

Hi, sorry to post in an open post but I have the exact same issue and the Hex character is '0D'.

Job design..

Database----------->Xfm----------------->seqfile

The database gets populated with mainframe file and the hex character is coming from that mainframe file. I do not have control over how the file gets populated to the database.

chulett · Post by **chulett** » Fri Dec 12, 2008 8:59 am

'0D' is a carriage return, usually a record terminator mismatch DOS to UNIX. Use Convert to remove them:

Code: Select all

Convert(CHAR(13),"",YourField)

If they are in data fields. If it is only at the end of the last field, change from UNIX to DOS terminators in the stage reading the file.

PhilHibbs · Post by **PhilHibbs** » Fri Dec 12, 2008 9:19 am

sagar deshmukh wrote:i am reading a cvs file into a sequential file. but i am getting box character in the output.please let me know if i need to apply any setting for this.

Are you getting any NLS warnings? If you have NLS-enabled DataStage installation, then try the ISO8859-1+MARKS UTF map on the source Sequential File.

wizee · Post by **wizee** » Fri Dec 12, 2008 9:42 am

Thanks Craig, this is resolved for me.

dslisa · Post by **dslisa** » Fri Dec 12, 2008 9:49 am

Me too. Don't know if worked out for Sagar.

dslisa · Post by **dslisa** » Fri Dec 12, 2008 9:50 am

Me too. Don't know if worked out for Sagar.

DSXchange

how to remove box character insequential file

how to remove box character insequential file

Re: how to remove box character insequential file