Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hard Enter in one column values
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hard Enter in one column values
Select your data in Excel, then fire up the VBA Editor (Alt+F11).
Copy following line to the "Immediate" Window and push Enter: Selection.Replace Chr(10), " " This will replace all Carriage Returns in the selection with a Space (substitute " " with "" if you just want to remove). If you need to do this regularly, you can put it into a proper macro: Sub RemoveReturns() Selection.Replace Chr(10), " " End Sub Cheers, Joerg Mochikun "Unnati" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find duplicate values in a column during enter the value? | Excel Discussion (Misc queries) | |||
How do I enter a Hard Return inside a cell? | Excel Discussion (Misc queries) | |||
How do I insert a hard break (alt enter) in a concatenated string | Excel Discussion (Misc queries) | |||
Convert Hard-coded cell values to constants | Excel Discussion (Misc queries) | |||
Hard values to convert to number | Excel Discussion (Misc queries) |