Re: [WebDNA] Reformatting database headers

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102506
interpreted = N
texte = 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]** 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)
  12. [WebDNA] Reformatting database headers ("Michael A. DeLorenzo" 2009)
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]** Donovan Brooke

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:

Webcat & SIMS (1998) Hierarchy of form/text/math variables (renamed thread) (2000) Under Score (1999) WebMerchant and Mac Auth Hub Help Please (1999) Replace context problem ... (1997) WebCat2 - [SendNews] (1997) RE: Help name our technology! (1997) listfiles, moving files (1998) Download capabilities (1997) WebCat2 beta 11 - new prefs ... (1997) SendMail on OS X (2003) WebCatalog Hosting (1996) This is a Test, sorry (1999) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Directory Overload (1998) XML version of WebDNA docs? (2000) Public Beta for WebCatalog 4.0 is Available (2000) French characters in variables (2001) RE: Re:Signal Raised (1997) Question about replacing words (1998)