RE: [WebDNA] Reformatting database headers
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102508
interpreted = N
texte = Hi Dan, Thanks for the input. I came up with this to rewrite a header file for the db. [writefile test.hdr][ListFields sasjcmls_res.db][FieldName] [/ListFields][/writefile] It seems to work but now I notice that I still have to cut out the original header file from the db. I'm guessing now that I'm using a header file with the db I can cut out the old headers by deleting everything front start of the file to the first return? Also, does anyone know if there are illegal characters you should not have in a header name? Michael -----Original Message----- From: Dan Strong [mailto:webdna@danstrong.com] Sent: Saturday, May 02, 2009 1:10 PM To: talk@webdna.us Subject: Re: [WebDNA] Reformatting database headers Cut the header line in the .db and paste it into a yourNewHDR.hdr file, then: [writefile file=thefinalHDR.hdr][grep search= &replace=_][include yourNewHDR.hdr][/grep][/writefile] -Dan On Sat, 2 May 2009 13:02:49 -0400 "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 > > > --------------------------------------------------------- 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:
Hi Dan, Thanks for the input. I came up with this to rewrite a header file for the db. [writefile test.hdr][ListFields sasjcmls_res.db][FieldName] [/ListFields][/writefile] It seems to work but now I notice that I still have to cut out the original header file from the db. I'm guessing now that I'm using a header file with the db I can cut out the old headers by deleting everything front start of the file to the first return? Also, does anyone know if there are illegal characters you should not have in a header name? Michael -----Original Message----- From: Dan Strong [mailto:webdna@danstrong.com] Sent: Saturday, May 02, 2009 1:10 PM To: talk@webdna.us Subject: Re: [WebDNA] Reformatting database headers Cut the header line in the .db and paste it into a yourNewHDR.hdr file, then: [writefile file=thefinalHDR.hdr][grep search= &replace=_][include yourNewHDR.hdr][/grep][/writefile] -Dan On Sat, 2 May 2009 13:02:49 -0400 "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 > > > --------------------------------------------------------- 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:
Not really WebCat (1997)
SiteEdit Pro Update Announcement (1997)
[Webcat 2]Next (1997)
empty shopping cart message (1997)
[WebDNA] Sorry WebDNA server not running. (2015)
Running 2 two WebCatalog.acgi's (1996)
Problems problems problems (1997)
Suddenly can't see files... (2000)
Emailer errors (1997)
RAM variables (1997)
Resume Catalog ? (1997)
Programmer needed (2001)
[WebDNA] NOT serving WebDNA, just running it locally. (2012)
return two fields w/ [lookup] (1998)
Listfiles context (2000)
3.08 has trouble keeping the serial # ?? (2000)
BannerAds example (1998)
Document Contains No Data! (1997)
[WebDNA] OT: just poking (2010)
I can help! (1996)