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:
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:
[sendmail] questions... (1997)
Logging purchases (1997)
gateway application timeouts (1998)
Newbie questions (1999)
billing system (2003)
Shipping charges depending on tax rate? (1997)
populating a table from multiple cookies (2005)
FYI: virus alert (1996)
Grep Help (2007)
Contribution (2000)
HELP WITH DATES (1997)
Requiring that certain fields be completed (1997)
HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
HELP! 10K hits per hour for pages that no longer exist! (2000)
Math (1997)
WebCatalog can't find database (1997)
[WebDNA] removed? (2018)
Weird problems with [SHOWIF]s (1997)
Help with Shipping Costs (1997)
A sendmail warning (2005)