Page 1 of 1
Special Character in Output Sequential File
Posted: Mon Apr 25, 2011 1:24 am
by Jayanto
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?
Posted: Mon Apr 25, 2011 1:45 am
by TPons
The information that you have given is not clear and more specific to give a solution to question.
Posted: Mon Apr 25, 2011 1:51 am
by Jayanto
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.
Posted: Mon Apr 25, 2011 4:24 am
by tbharathkumar
Are you getting this chracter along with "BIN" column?? what is the record delimiter used? is this UNIX or windows file?
Posted: Mon Apr 25, 2011 5:22 am
by Jayanto
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.
Posted: Mon Apr 25, 2011 6:44 am
by tbharathkumar
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.