XML values to database records (grep?)
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32904
interpreted = N
texte = I'm trying to parse some values from XML so that they can be appended as records into a database. So far I'm stumped as to how to parse this style of data using WebDNA. But I have the feeling that someone who is more fluent in grep than I (John Peacock hint hint nudge nudge) could see how to make this happen. The construct of the XML is listed below. I want to take each
, treat is as a database record, and append its s to the database using the pairs within each . So using the example below, I would like to be able to create an [append] context like this: [append db=x.db] channeltitle=NZ Jazz Online - Jazz.co.nz &id=75 &storytext=<a href=http://jazz.co.nz>Manuel Bundy</a> &time=19991004T02:01:13 [/append]Of course, I would like to extrapolate the data into an array of variables first so that I could manipulate it (change the date format for instance) before I append it to the database. *Note that some s have sub-identifiers such as and .XML: snip... channeltitle NZ Jazz Online - Jazz.co.nz id 75 storytext <a href=http://jazz.co.nz>Manuel Bundy</a> time 19991004T02:01:13 ...snip-- This is only one isolated . The entire XML source would have many s so my solution will need to recurs through the XML source and break each out as an individual record.Hmmf. Anyone? Ken? John? Grant?Thanks, Mike ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I'm trying to parse some values from XML so that they can be appended as records into a database. So far I'm stumped as to how to parse this style of data using WebDNA. But I have the feeling that someone who is more fluent in grep than I (John Peacock hint hint nudge nudge) could see how to make this happen. The construct of the XML is listed below. I want to take each , treat is as a database record, and append its s to the database using the pairs within each . So using the example below, I would like to be able to create an [append] context like this: [append db=x.db] channeltitle=NZ Jazz Online - Jazz.co.nz &id=75 &storytext=<a href=http://jazz.co.nz>Manuel Bundy</a> &time=19991004T02:01:13 [/append]Of course, I would like to extrapolate the data into an array of variables first so that I could manipulate it (change the date format for instance) before I append it to the database. *Note that some s have sub-identifiers such as and .XML: snip... channeltitle NZ Jazz Online - Jazz.co.nz id 75 storytext <a href=http://jazz.co.nz>Manuel Bundy</a> time 19991004T02:01:13 ...snip-- This is only one isolated . The entire XML source would have many s so my solution will need to recurs through the XML source and break each out as an individual record.Hmmf. Anyone? Ken? John? Grant?Thanks, Mike ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Mike Davis
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:
Mac: [ListFiles] bug alert (1997)
Location of Webcat site in folder hierarchy (1997)
HELP WITH DATES (1997)
[WriteFile] problems (1997)
passing cart value (2003)
Date sorting (1997)
Num Sort Descending (OT) (2004)
Upload Plugin (1998)
cart info (1998)
test (2004)
[WebDNA] writing pdfs on the fly (Avery labels #5160) (2010)
WebTen and WebCat (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
RE: counters from other site? (1998)
DataBaseHelper Flawed (1997)
problem with NT beta (1997)
SUBMIT buttons not working.... (2000)
creating a 60 fields database (1997)
WC Database Format (1997)
[WebDNA] GETCHARS ... words? (2009)