OraFAQ Forum: Server Utilities » cleaning data exported from excel

Home » RDBMS Server » Server Utilities » cleaning data exported from excel

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: cleaning data exported from excel [message #451990 is a reply to message #451989]

Mon, 19 April 2010 08:57

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How do you export it? In which format?

Regards
Michel

Report message to a moderator

Re: cleaning data exported from excel [message #451991 is a reply to message #451990]

Mon, 19 April 2010 09:00

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?

Report message to a moderator

Re: cleaning data exported from excel [message #451993 is a reply to message #451991]

Mon, 19 April 2010 09:14

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/

Report message to a moderator

Re: cleaning data exported from excel [message #451995 is a reply to message #451991]

Mon, 19 April 2010 09:32

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.)

Report message to a moderator

Re: cleaning data exported from excel [message #451998 is a reply to message #451995]

Mon, 19 April 2010 09:55

puranikkaustubh
Messages: 14
Registered: April 2010
Location: pune

Junior Member

still its not working

Report message to a moderator

Re: cleaning data exported from excel [message #452005 is a reply to message #451991]

Mon, 19 April 2010 10:10

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: cleaning data exported from excel [message #452018 is a reply to message #451998]

Mon, 19 April 2010 11:09

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.

Report message to a moderator

Re: cleaning data exported from excel [message #452022 is a reply to message #451998]

Mon, 19 April 2010 11:22

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/

Report message to a moderator