Kitty , it is nice on your part to share the solution with the list.
For future : (On the lines of what Stefan said)
May be dd if=inputfile of=outputfile conv=ebcdic/ebcdicb/ibm/ibmb might
have
helped. Check with "man dd".
The suggestion given by Raj is worth keeping in mind.
HTH
GovindanK
On
Hi List,
Finally, I used HexCmp and found out the file generated by Oracle PLSQL or report
writer only contains a CR (chr(13)) even if I had a chr(13) and chr(10) in the query.
I re-wrote my export scripts in java, then resulting file is OK.
Thanks to all of you who responded my problem.
Ha
sorry your attachments were filtered out ... can you attach them as txt files?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, h
The size do differ between two files.
I attached both files. The problem is between the end of line2 "/" and the begin of
line3 "2" in the customer.txt.
Thanks,
Kitty
-Original Message-
Sent: Friday, November 14, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Kitty,
when t
Maybe possible that this is related to what Unix needs at that end of a line
and what DOS needs at the end of line and what happens when such files get
FTP-ed in ascii mode from one to the other?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET:
Title: RE: LF and CR (chr(10)||chr(13)) problem
Then you should use an editor that is capable to show file contents in hex. Or you can use a program that compares two files - the original and the one "transformed" by notepad and see the difference.
Regards, Joze
-Origin
Kitty,
when the file is written by pl/sql note its size. Then open and save in notepad and
note its size. If both sizes are different, you know there is a CR/LF problem, else
problems is somewhere else.
Raj
Rajendr
Peter,
Thanks for your input.
You misunderstood the problem. The point is the SAP needs that LF and CR (chr(10) and
chr(13)).
Of course, I used a hex editor to look at it, they are OK (0A and 0D). That's why it
is frustrate.
Anybody who had a similar problem before, please help me.
Thanks,
K
Joze,
It's not that simply. I already tried all the possible combination: chr(13)||chr(10) ,
chr(10)||chr(13), chr(13) , chr(10)||chr(10)...
Thanks for your input anyway.
Regards,
Kitty
-Original Message-
Sent: Friday, November 14, 2003 6:09 AM
To: Multiple recipients of list ORACLE-L
Strip out the chr(10) and chr(13) using
update tname set field = replace(field,chr(13),' ')
where instr(column_name,chr(13)) > 0 having count(*) > 0;'
BUT check whether you want to replace your chr(10) and chr(13) with a space(
' ') or nothing ('').
Use the above 'where' clause in a select t
The solution is simple. The correct sequence of characters is not
chr(10)||chr(13) but rather chr(13)||chr(10). This is obviously changed
by notepad.
regards, Joze
-Original Message-
Sent: Friday, November 14, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L
Hi,
Currently I am
11 matches
Mail list logo
