Re: [WebDNA] XML parsing issue with cdata

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 109149
interpreted = N
texte = --0016e6d7df6a20489b04c10f6418 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hmm. i am stuck again it seems, I can get the data via xlst, but writing it to a db seems really awkward, i think I need to look at another solution. So how do you use middle to get the value to actually show up? d. On Sun, May 27, 2012 at 7:23 PM, Stuart Tremain wrote: > I use MIDDLE to get past the [CDATA > > > On 27/05/2012, at 1:35 AM, David Bastedo wrote: > > Hi, has anybody run into the following xml parsing issue? > > The node: ones at Snow City.]]> > > I can see the content I want in an xml file. in the CDATA abvoe - being > the content of a tweet "RT @BoyTopi: I want to feel snow! Not the fake on= es > at Snow City." > > the value of the "text" node returns a blank. > > if I get a node attribute of "text" then I get a return name value of > "#cdata-section" and no "value" > > How do I get to the CDATA information in the following example. > > Any ideas? Is there something I am missing? > > thanks. > > d. > > sample: xml > > tweets_locarea 2064055189= 25905920 1338045885 803 Hesperia_WX 25 unknown US United States Of America= 1 USCA0481 CA Hesperia > > > sample parse > > --tweet: > ---klass: tweets_locarea > ---tweetId: 206405503587328000 > ---date: 1338045881 > ---text: > ----#cdata-section: ------------------> the offending line > ---sentiment: > ---dma: 803 > ---tweeter: > ----screenName: HeyAbbie_ > ----influence: 27 > ----gender: female > ----profileImageURL: > -----#cdata-section: ------------------> the offending line > ---location: > ----countryCode: US > ----country: United States Of America > ----type: 1 > ----id: USCA0638 > ----state: CA > ----name: Los Angeles > > > > --------------------------------------------------------- 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 Bug Reporting: support@webdna.u= s > **** > > > --------------------------------------------------------- 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 Bug Reporting: support@webdna.u= s --=20 --=20 David Bastedo Ten Plus One Communications Inc. http://www.10plus1.com 416.277.4499 My Profiles [image: LinkedIn] [ima= ge: Delicious] [image: Twitter] [image: Google] Find me on [image: Google Talk] davidbmbastedo@gmail.com My Latest Shared Link is: QR code stickers turn real-world objects into digital conversations | Springwise --0016e6d7df6a20489b04c10f6418 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hmm. i am stuck again it seems, I can get the data via xlst, but writing it= to a db seems really awkward, i think I need to look at another solution. = So how do you use middle to get the value to actually show up?

d.


On Sun, May 27, 2012 at 7:23 PM, Stuart = Tremain <webdna@idfk.com.au> wrote:
I use MIDDLE to get past the [CDATA

On 27/05/2012, at 1:35= AM, David Bastedo wrote:

Hi, has anybody run into the following xml parsing issue?=

The node: =A0 <text><![CDATA[RT @BoyTopi: I want to feel s= now! Not the fake ones at Snow City.]]></text>
=A0
I can see= the content I want in an xml file. in the CDATA abvoe - being the content = of a tweet "RT @BoyTopi: I want to feel snow! Not the fake ones at Sno= w City."

the value of the "text" node returns a blank.

if I ge= t a node attribute of "text" then I get a return name value of &q= uot;#cdata-section" and no "value"

How do I get to th= e CDATA information in the following example.

Any ideas? Is there something I am missing?

thanks.

d.
sample: xml
<tweets>  <tweet>    <klass>tweets=_locarea</klass>    <tweetid>2064=05518925905920</tweetid>    <date>1338045=885</date>    <text>=<!--[CDATA[HA: Fair and Breezy and 50 F at Southern California Log=isitics Airport, CA Winds are from the West at 20.7 gusting to 2 http://t.co/KqLrqbuk]]--></text>    <sentiment>    <dma>803</dma>    <tweeter>      <screenname>Hesperia_WX</screenname>      <influence>=25</influence>      <gender>unk=nown</gender>      <profileimageurl>=<!--[CDATA[http=://a0.twimg.com/profile_images/383407737/Official_SWAS_logo_normal.jpg]]--<=/a>></profileimageurl>    </tweeter>    <location>      <countrycode>US</countrycode>      <country>Un=ited States Of America</country>      <type>1</type>      <id>USCA048=1</id>      <state>CA</state>      <name>Hespe=ria</name>    </location>  </sentiment></tweet>  <tweet><=/pre>
sample parse

--tweet:=20
=20 ---klass: tweets_locarea
=20 =20 =20 =20 ---tweetId: 206405503587328000
=20 =20 =20 =20 ---date: 1338045881
=20 =20 =20 =20 ---text:
=20 =20 =20 =20 ----#cdata-section: ------------------> the offending line
=20 =20 =20 ---sentiment:
=20 =20 =20 =20 ---dma: 803
=20 =20 =20 =20 ---tweeter:=20
=20 =20 =20 =20 ----screenName: HeyAbbie_
=20 =20 =20 ----influence: 27
=20 =20 =20 ----gender: female
=20 =20 =20 ----profileImageURL:
=20 =20 =20 -----#cdata-section: ------------------> the offending line
=20 =20 ---location:=20
=20 =20 =20 =20 ----countryCode: US
=20 =20 =20 ----country: United States Of America
=20 =20 =20 ----type: 1
=20 =20 =20 ----id: USCA0638
=20 =20 =20 ----state: CA
=20 =20 =20 ----name: Los Angeles

=A0

--------------------------------------------------------- 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 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- 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 Bug Reporting: suppo= rt@webdna.us


--

--
David Bastedo<= br>Ten Plus One Communications Inc.
http://www.10plus1.com
416.277.4499

My Profiles 3D"LinkedIn" 3D"Delicio=us"= 3D"Twitter" 3D"Google"
Find me on 3D"Google davidbmbastedo@gmail.com<= /a>
My Latest Shared Link is: QR code stickers turn real-world objects= into digital conversations | Springwise

--0016e6d7df6a20489b04c10f6418-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] XML parsing issue with cdata (David Bastedo 2012)
  2. Re: [WebDNA] XML parsing issue with cdata (David Bastedo 2012)
  3. Re: [WebDNA] XML parsing issue with cdata (Stuart Tremain 2012)
  4. Re: [WebDNA] XML parsing issue with cdata (David Bastedo 2012)
  5. Re: [WebDNA] XML parsing issue with cdata (Stuart Tremain 2012)
  6. Re: [WebDNA] XML parsing issue with cdata (Stuart Tremain 2012)
  7. Re: [WebDNA] XML parsing issue with cdata (David Bastedo 2012)
  8. Re: [WebDNA] XML parsing issue with cdata (David Bastedo 2012)
  9. Re: [WebDNA] XML parsing issue with cdata (David Bastedo 2012)
  10. Re: [WebDNA] XML parsing issue with cdata (Donovan Brooke 2012)
  11. Re: [WebDNA] XML parsing issue with cdata (D Brooke 2012)
  12. [WebDNA] XML parsing issue with cdata (David Bastedo 2012)
--0016e6d7df6a20489b04c10f6418 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hmm. i am stuck again it seems, I can get the data via xlst, but writing it to a db seems really awkward, i think I need to look at another solution. So how do you use middle to get the value to actually show up? d. On Sun, May 27, 2012 at 7:23 PM, Stuart Tremain wrote: > I use MIDDLE to get past the [CDATA > > > On 27/05/2012, at 1:35 AM, David Bastedo wrote: > > Hi, has anybody run into the following xml parsing issue? > > The node: ones at Snow City.]]> > > I can see the content I want in an xml file. in the CDATA abvoe - being > the content of a tweet "RT @BoyTopi: I want to feel snow! Not the fake on= es > at Snow City." > > the value of the "text" node returns a blank. > > if I get a node attribute of "text" then I get a return name value of > "#cdata-section" and no "value" > > How do I get to the CDATA information in the following example. > > Any ideas? Is there something I am missing? > > thanks. > > d. > > sample: xml > > tweets_locarea 2064055189= 25905920 1338045885 803 Hesperia_WX 25 unknown US United States Of America= 1 USCA0481 CA Hesperia > > > sample parse > > --tweet: > ---klass: tweets_locarea > ---tweetId: 206405503587328000 > ---date: 1338045881 > ---text: > ----#cdata-section: ------------------> the offending line > ---sentiment: > ---dma: 803 > ---tweeter: > ----screenName: HeyAbbie_ > ----influence: 27 > ----gender: female > ----profileImageURL: > -----#cdata-section: ------------------> the offending line > ---location: > ----countryCode: US > ----country: United States Of America > ----type: 1 > ----id: USCA0638 > ----state: CA > ----name: Los Angeles > > > > --------------------------------------------------------- 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 Bug Reporting: support@webdna.u= s > **** > > > --------------------------------------------------------- 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 Bug Reporting: support@webdna.u= s --=20 --=20 David Bastedo Ten Plus One Communications Inc. http://www.10plus1.com 416.277.4499 My Profiles [image: LinkedIn] [ima= ge: Delicious] [image: Twitter] [image: Google] Find me on [image: Google Talk] davidbmbastedo@gmail.com My Latest Shared Link is: QR code stickers turn real-world objects into digital conversations | Springwise --0016e6d7df6a20489b04c10f6418 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hmm. i am stuck again it seems, I can get the data via xlst, but writing it= to a db seems really awkward, i think I need to look at another solution. = So how do you use middle to get the value to actually show up?

d.


On Sun, May 27, 2012 at 7:23 PM, Stuart = Tremain <webdna@idfk.com.au> wrote:
I use MIDDLE to get past the [CDATA

On 27/05/2012, at 1:35= AM, David Bastedo wrote:

Hi, has anybody run into the following xml parsing issue?=

The node: =A0 <text><![CDATA[RT @BoyTopi: I want to feel s= now! Not the fake ones at Snow City.]]></text>
=A0
I can see= the content I want in an xml file. in the CDATA abvoe - being the content = of a tweet "RT @BoyTopi: I want to feel snow! Not the fake ones at Sno= w City."

the value of the "text" node returns a blank.

if I ge= t a node attribute of "text" then I get a return name value of &q= uot;#cdata-section" and no "value"

How do I get to th= e CDATA information in the following example.

Any ideas? Is there something I am missing?

thanks.

d.
sample: xml
<tweets>  <tweet>    <klass>tweets=_locarea</klass>    <tweetid>2064=05518925905920</tweetid>    <date>1338045=885</date>    <text>=<!--[CDATA[HA: Fair and Breezy and 50 F at Southern California Log=isitics Airport, CA Winds are from the West at 20.7 gusting to 2 http://t.co/KqLrqbuk]]--></text>    <sentiment>    <dma>803</dma>    <tweeter>      <screenname>Hesperia_WX</screenname>      <influence>=25</influence>      <gender>unk=nown</gender>      <profileimageurl>=<!--[CDATA[http=://a0.twimg.com/profile_images/383407737/Official_SWAS_logo_normal.jpg]]--<=/a>></profileimageurl>    </tweeter>    <location>      <countrycode>US</countrycode>      <country>Un=ited States Of America</country>      <type>1</type>      <id>USCA048=1</id>      <state>CA</state>      <name>Hespe=ria</name>    </location>  </sentiment></tweet>  <tweet><=/pre>
sample parse

--tweet:=20
=20 ---klass: tweets_locarea
=20 =20 =20 =20 ---tweetId: 206405503587328000
=20 =20 =20 =20 ---date: 1338045881
=20 =20 =20 =20 ---text:
=20 =20 =20 =20 ----#cdata-section: ------------------> the offending line
=20 =20 =20 ---sentiment:
=20 =20 =20 =20 ---dma: 803
=20 =20 =20 =20 ---tweeter:=20
=20 =20 =20 =20 ----screenName: HeyAbbie_
=20 =20 =20 ----influence: 27
=20 =20 =20 ----gender: female
=20 =20 =20 ----profileImageURL:
=20 =20 =20 -----#cdata-section: ------------------> the offending line
=20 =20 ---location:=20
=20 =20 =20 =20 ----countryCode: US
=20 =20 =20 ----country: United States Of America
=20 =20 =20 ----type: 1
=20 =20 =20 ----id: USCA0638
=20 =20 =20 ----state: CA
=20 =20 =20 ----name: Los Angeles

=A0

--------------------------------------------------------- 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 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- 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 Bug Reporting: suppo= rt@webdna.us


--


--0016e6d7df6a20489b04c10f6418-- David Bastedo

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:

Prevent multiple appends with Reload Button (1997) Friday Morning Funnies (2003) Comments in db? (1997) Removing [showif] makes a big difference in speed (1997) Add to a filename in multifile upload (2002) Word search (1997) Date problems-more (1997) WebDNA 5 - Privacy Issue (Built in sniffer) (2003) WebCat2b13MacPlugIn - More limits on [include] (1997) [WebDNA] WebDNA code validator (2011) [WC 2.1.30] Stack overflow. (2000) WebCat2b15MacPlugin - [protect] (1997) What's New Date (2002) Question re: FlushDatabases (1997) WC1.6 to WC2 date formatting -FIXED! (1997) [LISTFILES] (1998) [url] issue (2000) Search in 2 or more catalogs (1997) Shipping cost out of synch (1998) & in Lookups (1997)