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
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: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please post a sample (small) data.
We can definately deal this with some scripting.
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: 10672
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.
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
Previous Topic: Export using Parameter file and then ( Cron Job )
Next Topic: How can Import Foxpro DBF date into ORACLE 8.0
Goto Forum:
  


Current Time: Sat Dec 03 18:10:43 CST 2016

Total time taken to generate the page: 0.04948 seconds