OraFAQ Forum: Server Utilities » selective csv file loading

Home » RDBMS Server » Server Utilities » selective csv file loading

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

selective csv file loading [message #195787]

Mon, 02 October 2006 07:02

srraajesh
Messages: 63
Registered: May 2005

Member

Hi Gurus,

I have .csv file with ctrl+A (^A) as field separator. Now, it is not of fixed format, and I have to load selective fields from the .csv file to a table.It also consists a header.

I proceeded like this

Gave a hex based terminator to the CSV file.

FIELDS TERMINATED BY ''
OPTIONALLY ENCLOSED BY '"'

Now, I would like to know how to do selective field insert. As it is not of fixed format, I cannot use POSITION. Can somebody help out with a solution.

Thanks in Advance.
Srr

Report message to a moderator

Re: selective csv file loading [message #195824 is a reply to message #195787]

Mon, 02 October 2006 11:53

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please post a sample (small) data.
We can definately deal this with some scripting.

Report message to a moderator

Re: selective csv file loading [message #195826 is a reply to message #195824]

Mon, 02 October 2006 11:55

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Did you also try using FILLER?
http://www.orafaq.com/forum/t/26690/0/
Search the board for more examples.

Report message to a moderator

Re: selective csv file loading [message #195837 is a reply to message #195787]

Mon, 02 October 2006 13:44

srraajesh
Messages: 63
Registered: May 2005

Member

Hi,

I tried using FILLER and it was too good..the issue is resolved..

Thanks!! Smile

srr

Report message to a moderator

Previous Topic:	Export using Parameter file and then ( Cron Job )
Next Topic:	How can Import Foxpro DBF date into ORACLE 8.0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 00:10:28 CST 2024