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 entire database as it needs to be an automated function. Does it make any sense to use 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 PM To: talk@webdna.us Subject: Re: [WebDNA] Reformatting database headers Michael 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. > Michael If it's just one .db.. use bbedit and highlight the fieldname line, the find/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 Brooke WebDNA Software Corporation http://www.webdna.us **[Square Bracket Utopia]** --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us old archives: http://dev.webdna.us/TalkListArchive/ Associated Messages, from the most recent to the oldest:

    
  1. RE: [WebDNA] Reformatting database headers ("Michael A. DeLorenzo" 2009)
  2. Re: [WebDNA] Reformatting database headers ("Dan Strong" 2009)
  3. Re: [WebDNA] Reformatting database headers (Donovan Brooke 2009)
  4. RE: [WebDNA] Reformatting database headers ("Michael A. DeLorenzo" 2009)
  5. Re: [WebDNA] Reformatting database headers (Donovan Brooke 2009)
  6. RE: [WebDNA] Reformatting database headers ("Michael A. DeLorenzo" 2009)
  7. RE: [WebDNA] Reformatting database headers ("Michael A. DeLorenzo" 2009)
  8. RE: [WebDNA] Reformatting database headers ("Michael A. DeLorenzo" 2009)
  9. Re: [WebDNA] Reformatting database headers (Donovan Brooke 2009)
  10. Re: [WebDNA] Reformatting database headers (Donovan Brooke 2009)
  11. Re: [WebDNA] Reformatting database headers ("Dan Strong" 2009)
Thanks Donovan. I was thinking that I might need to just rewrite the entire database as it needs to be an automated function. Does it make any sense to use 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 PM To: talk@webdna.us Subject: Re: [WebDNA] Reformatting database headers Michael 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. > Michael If it's just one .db.. use bbedit and highlight the fieldname line, the find/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 Brooke WebDNA Software Corporation http://www.webdna.us **[Square Bracket Utopia]** --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us old 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)