| cleaning data exported from excel [message #451989] |
Mon, 19 April 2010 08:54  |
puranikkaustubh
Messages: 14
Registered: April 2010
Location: pune
|
Junior Member |
|
|
hi
i have exported data from excel. data is exported successfully but with it some characters are also joind. it happend with evry row in the table. what is to be done to remove it? and what to do with columns whos data type is number?
data is as follows underlined are the char. which are joind while transfer
eid ename age salary
123 MARK 31 40000
|
|
|
|
|
|
|
|
|
|
| Re: cleaning data exported from excel [message #451995 is a reply to message #451991] |
Mon, 19 April 2010 09:32  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
Probably a problem with the file encoding.
Make sure the NLS_LANG environment is set up correctly when the file is loaded. (Encoding UTF-8, or possibly WE8MSWIN1252, depending on how and on which OS you do the export.)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
