Re: CSV import suggestions

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 69158
interpreted = N
texte = How do I prevent WebDNA from caching these imported files. Can I not read these files in and extract the data I need line by line checking for "," and CR? Your suggestion would still require me to create another db in memory in order to import the data. Vince -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of John Peacock Sent: Thursday, July 05, 2007 12:45 PM To: WebDNA Talk Subject: Re: CSV import suggestions Vincent Medina wrote: > Anyone have any suggestions for me. I need to import a CSV file into a > webdna db. Type the following on one line: perl -MText::ParseWords -ne 'print join("\t", quotewords(",",0,$_[0])' < csv_file > tab_file YMMV under Windows (the quoting may need tweaking). John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: CSV import suggestions ( "Vincent Medina" 2007)
  2. Re: CSV import suggestions ( "Vincent Medina" 2007)
  3. Re: CSV import suggestions ( "Vincent Medina" 2007)
  4. Re: CSV import suggestions ( Matthew A Perosi 2007)
  5. Re: CSV import suggestions ( Stuart Tremain 2007)
  6. Re: CSV import suggestions ( John Peacock 2007)
  7. Re: CSV import suggestions ( Donovan Brooke 2007)
  8. Re: CSV import suggestions ( "Gary Krockover" 2007)
  9. Re: CSV import suggestions ( Donovan Brooke 2007)
  10. Re: CSV import suggestions ( "Vincent Medina" 2007)
  11. Re: CSV import suggestions ( "Vincent Medina" 2007)
  12. Re: CSV import suggestions ( "Vincent Medina" 2007)
  13. Re: CSV import suggestions ( "Vincent Medina" 2007)
  14. Re: CSV import suggestions ( John Peacock 2007)
  15. Re: CSV import suggestions ( Donovan Brooke 2007)
  16. Re: CSV import suggestions ( Paul Willis 2007)
  17. Re: CSV import suggestions ( John Peacock 2007)
  18. CSV import suggestions ( "Vincent Medina" 2007)
How do I prevent WebDNA from caching these imported files. Can I not read these files in and extract the data I need line by line checking for "," and CR? Your suggestion would still require me to create another db in memory in order to import the data. Vince -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of John Peacock Sent: Thursday, July 05, 2007 12:45 PM To: WebDNA Talk Subject: Re: CSV import suggestions Vincent Medina wrote: > Anyone have any suggestions for me. I need to import a CSV file into a > webdna db. Type the following on one line: perl -MText::ParseWords -ne 'print join("\t", quotewords(",",0,$_[0])' < csv_file > tab_file YMMV under Windows (the quoting may need tweaking). John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "Vincent Medina"

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

affiliate marketing program (1998) DBServer.exe (2003) [FEATURE REQUEST] (2004) test (2004) request for new command (1997) Tried installing Windows beta with no success... (2000) [addlineitems] (1997) Search Combining Problem (2004) Sorting error (1997) Order not created error (1997) Why does this not work? (2002) WebCat hosting providers? (1997) [WebDNA] a major shift in strategy? (2008) WebCat2b13 Command Reference Doc error (1997) ARGH! (2004) Wrapping text (1998) FM PRO Compatibility Issue - Single Database w/oConversions (1997) A little syntax help (1997) trouble updating records in database (1998) WebCat/CyberStudio Compatibility (1998)