Home » RDBMS Server » Server Utilities » selective csv file loading
selective csv file loading [message #195787] Mon, 02 October 2006 07:02 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 06:26:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.