Home » RDBMS Server » Server Utilities » cleaning data exported from excel
cleaning data exported from excel [message #451989] Mon, 19 April 2010 08:54 Go to next message
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 #451990 is a reply to message #451989] Mon, 19 April 2010 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How do you export it? In which format?

Regards
Michel
Re: cleaning data exported from excel [message #451991 is a reply to message #451990] Mon, 19 April 2010 09:00 Go to previous messageGo to next message
puranikkaustubh
Messages: 14
Registered: April 2010
Location: pune
Junior Member
i am using sqlldr.

eid varchar
ename varchar
age number
salary number

when those char. are attached with number it doesnt get inserted what to do with it?
Re: cleaning data exported from excel [message #451993 is a reply to message #451991] Mon, 19 April 2010 09:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>when those char. are attached with number it doesnt get inserted what to do with it?

How can we reproduce your problem?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: cleaning data exported from excel [message #451995 is a reply to message #451991] Mon, 19 April 2010 09:32 Go to previous messageGo to next message
ThomasG
Messages: 3211
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.)
Re: cleaning data exported from excel [message #451998 is a reply to message #451995] Mon, 19 April 2010 09:55 Go to previous messageGo to next message
puranikkaustubh
Messages: 14
Registered: April 2010
Location: pune
Junior Member
still its not working
Re: cleaning data exported from excel [message #452005 is a reply to message #451991] Mon, 19 April 2010 10:10 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How do you export it? In which format?

Quote:
i am using sqlldr.

You surely NOT use sqlldr to EXPORT.

Regards
Michel
Re: cleaning data exported from excel [message #452018 is a reply to message #451998] Mon, 19 April 2010 11:09 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
puranikkaustubh wrote on Mon, 19 April 2010 16:55
still its not working


Still you are using the wrong encoding.
Re: cleaning data exported from excel [message #452022 is a reply to message #451998] Mon, 19 April 2010 11:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
puranikkaustubh wrote on Mon, 19 April 2010 07:55
still its not working


We don't know what you have.
We don't know what you do.
We don't know what you see.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: cleaning data exported from excel [message #452110 is a reply to message #452018] Tue, 20 April 2010 02:03 Go to previous messageGo to next message
puranikkaustubh
Messages: 14
Registered: April 2010
Location: pune
Junior Member
thank you
problem solved
Re: cleaning data exported from excel [message #452112 is a reply to message #452110] Tue, 20 April 2010 02:12 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How? What was the problem?

Regards
Michel
Re: cleaning data exported from excel [message #452114 is a reply to message #452112] Tue, 20 April 2010 02:17 Go to previous message
puranikkaustubh
Messages: 14
Registered: April 2010
Location: pune
Junior Member
the issue was regarding NLS_LANG environment
Previous Topic: Direct Path Loading
Next Topic: Export Schema failed
Goto Forum:
  


Current Time: Sun Sep 19 21:05:02 CDT 2021