dbTalk Databases Forums  

package for manipulating cvs data?

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss package for manipulating cvs data? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mh@pixar.com
 
Posts: n/a

Default package for manipulating cvs data? - 03-25-2009 , 12:21 AM






Specifically, I would like to take some columns or other data and
create a well-formed cvs string, including proper handling of
embedded quotes, commas, etc.

Is there a standard package that has this kind of functionality?

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios

Reply With Quote
  #2  
Old   
ddf
 
Posts: n/a

Default Re: package for manipulating cvs data? - 03-25-2009 , 07:24 AM






On Mar 25, 1:21*am, m... (AT) pixar (DOT) com wrote:
Quote:
Specifically, I would like to take some columns or other data and
create a well-formed cvs string, including proper handling of
embedded quotes, commas, etc.

Is there a standard package that has this kind of functionality?

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios
Are you asking about CSV strings?


David Fitzjarrell


Reply With Quote
  #3  
Old   
Paulie
 
Posts: n/a

Default Re: package for manipulating cvs data? - 03-25-2009 , 11:45 AM




On Mar 25, 6:21*am, m... (AT) pixar (DOT) com wrote:


Quote:
Specifically, I would like to take some columns or other data and
create a well-formed cvs string, including proper handling of
embedded quotes, commas, etc.

I think you should look at Tom Kyte's asktom site - there's
a PL/SQL procedure there for saving arbitrary queries as
..csv.

You could get a couple of ideas here

http://www.oracle-base.com/dba/Scrip...s&file=csv.sql

It's always amazed me that nobody has written a proper .csv
manipulation package for Oracle, given all the questions that
people ask about it - ho... hum... maybe next year.


Quote:
Is there a standard package that has this kind of functionality?

There are lot's of snippets out there - Mr. SearchEngine is your
friend...


Paul...


Quote:
Mark


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.