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:

    
  1. Re: XML values to database records (grep?) (Mike Davis 2000)
  2. Re: XML values to database records (grep?) (John Peacock 2000)
  3. XML values to database records (grep?) (Mike Davis 2000)
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:

[sendmail] sending twice... (Update) (2003) SSL (1998) OS X (2000) Pre-parse hell (2008) Help! WebCat2 bug (1997) formatting dates from a field ... (1997) WebCat cannot handle compatible search parameters? (1997) [LOOKUP] (1997) GuestBook example (1997) emailer (1997) Getting the width and height of gif files (2000) Bug or syntax error on my part? (1997) Proper file locations (1997) Multiple catalog databases and showcart (1997) [format 40s]text[/format] doesn't work (1997) Line Feed Character Appended (1998) [WebDNA] Version control (git or subversion) workflow for WebDNA (2012) sorting and grouping (1998) WebDNA Solutions ... sorry! (1997) back button loses cart (2000)