Special Character in Output Sequential File

Jayanto · Post by **Jayanto** » Mon Apr 25, 2011 1:24 am

Hello,

I am getting a special character in my output Sequential file.
Even though, I do not have this character in the source Sequential file.
Due to this the target file is getting a newLine character.

How can I handle this?

TPons · Post by **TPons** » Mon Apr 25, 2011 1:45 am

The information that you have given is not clear and more specific to give a solution to question.

Jayanto · Post by **Jayanto** » Mon Apr 25, 2011 1:51 am

In my source Sequential File, I have a field "BIN"(Varchar(20)). When am mapping this field to my target Sequential File, which is also "BIN"(Varchar(20)).
Then in the target Sequential file, am getting the special character.

Please letme, if any more clarification is needed.

tbharathkumar · Post by **tbharathkumar** » Mon Apr 25, 2011 4:24 am

Are you getting this chracter along with "BIN" column?? what is the record delimiter used? is this UNIX or windows file?

Jayanto · Post by **Jayanto** » Mon Apr 25, 2011 5:22 am

The BIN Column from source file has no Value. But in the target file, it is showing a special character <CR> in the BIN Field.
It is a Windows File.

tbharathkumar · Post by **tbharathkumar** » Mon Apr 25, 2011 6:44 am

think it's Carriage return charater, Check ur source file with text pad for better understanding file format(i.e record, line and EOF delimiters.