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 readthese files in and extract the data I need line by line checking for "," andCR?Your suggestion would still require me to create another db in memory inorder to import the data. Vince-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of JohnPeacockSent: Thursday, July 05, 2007 12:45 PMTo: WebDNA TalkSubject: Re: CSV import suggestionsVincent 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_fileYMMV under Windows (the quoting may need tweaking).John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 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 toWeb 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:
How do I prevent WebDNA from caching these imported files. Can I not readthese files in and extract the data I need line by line checking for "," andCR?Your suggestion would still require me to create another db in memory inorder to import the data. Vince-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of JohnPeacockSent: Thursday, July 05, 2007 12:45 PMTo: WebDNA TalkSubject: Re: CSV import suggestionsVincent 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_fileYMMV under Windows (the quoting may need tweaking).John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 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 toWeb 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)