RE: [WebDNA] Reformatting database headers
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102509
interpreted = N
texte = Thanks Donovan. I was thinking that I might need to just rewrite the entiredatabase as it needs to be an automated function. Does it make any sense touse anything I sent in my last reply to Dan?Michael-----Original Message-----From: Donovan Brooke [mailto:dbrooke@webdna.us] Sent: Saturday, May 02, 2009 1:14 PMTo: talk@webdna.usSubject: Re: [WebDNA] Reformatting database headersMichael A. DeLorenzo wrote:> I need to use a database file sent to me which has headers with spaces > in the names. Ideally I would like to rename each one with an underscore > in place of each space in the header name. Can someone put me on the > right track to do this? The database is about 7MB and has 280 fields.> MichaelIf it's just one .db.. use bbedit and highlight the fieldname line, thefind/replace.If it's an automated process... something like:[writefile file=newdb.db][grep search=[url] [/url]&replace=|][middle startafter=&endbefore=[/unurl]%0D[/unurl]][include file=olddb.db&raw=T][/middle][/grep][/writefile][movefile from=olddb.db&to=archives/olddb.db.bu]-- Donovan BrookeWebDNA Software Corporationhttp://www.webdna.us**[Square Bracket Utopia]**---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list
.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usold archives: http://dev.webdna.us/TalkListArchive/
Associated Messages, from the most recent to the oldest:
Thanks Donovan. I was thinking that I might need to just rewrite the entiredatabase as it needs to be an automated function. Does it make any sense touse anything I sent in my last reply to Dan?Michael-----Original Message-----From: Donovan Brooke [mailto:dbrooke@webdna.us] Sent: Saturday, May 02, 2009 1:14 PMTo: talk@webdna.usSubject: Re: [WebDNA] Reformatting database headersMichael A. DeLorenzo wrote:> I need to use a database file sent to me which has headers with spaces > in the names. Ideally I would like to rename each one with an underscore > in place of each space in the header name. Can someone put me on the > right track to do this? The database is about 7MB and has 280 fields.> MichaelIf it's just one .db.. use bbedit and highlight the fieldname line, thefind/replace.If it's an automated process... something like:[writefile file=newdb.db][grep search=[url] [/url]&replace=|][middle startafter=&endbefore=[/unurl]%0D[/unurl]][include file=olddb.db&raw=T][/middle][/grep][/writefile][movefile from=olddb.db&to=archives/olddb.db.bu]-- Donovan BrookeWebDNA Software Corporationhttp://www.webdna.us**[Square Bracket Utopia]**---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usold archives: http://dev.webdna.us/TalkListArchive/
"Michael A. DeLorenzo"
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:
Setting up WebCatalog with Retail Pro data (1996)
Not really WebCat (1997)
hideif glitch (2003)
Pithy questions on webcommerce & siteedit (1997)
Price written to db as scientific notation??? (1999)
Sample Email Catalog Order? (1998)
shipping & multiple comparisons? (2000)
Mac: [ListFiles] bug alert (1997)
NT vs Mac (1997)
problems with WebCat-Plugin ()
Email notification to one of multiple vendors ? (1997)
[WebDNA] Image Magick and Webdna (2009)
Emailer [cart] file names (1997)
Show items based on login Password (2003)
Non HTML file protection - OS X (webstar or apache) (2002)
db creator (2000)
pc (1997)
Paypal merchant code tricks or pitfalls (2003)
about this server and links to who (1997)
Re[2]: 2nd WebCatalog2 Feature Request (1996)