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:

FREE Stuff .. (2003) carriage returns in data (1997) Another new bug found ... (2000) [include file=filename.inc&strip=t] (2002) spawn (1998) [shownext max=?] armed (1997) Summing fields (1997) What is the best way to share load with Web Cat and mac (2000) Error cart approval pending (2005) Not reading code (1997) 3.08 installer (2003) WC2.0 Memory Requirements (1997) Protect (1997) UPDATE PROBLEM (1997) Re:need help please (1997) Wrapping text (1998) restarting service remotely on NT (1997) if else problem (2003) Calendar (1997) upgrade? (1997)