Hard Enter in one column values
You could also do the change via the user interface.
Select the range to fix
Edit|replace
what: ctrl-j
with: (space character)
replace all
========
I don't use oracle, but if it supports newlines in its fields, you may want to
change the alt-enter to a unique character (like a |). Import this data into
Oracle and then do something(?) in oracle to change that character back to a
linefeed.
Unnati wrote:
Hi,
I am trying to convert XLS to CSV and then load to Oracle. But in XLS i
have some field value with Carriage Return. So it is making new records. Is
there anyway i can do while converting? I have couple of them coming
frequently.
--
Dave Peterson
|