Re: [WebDNA] XML parsing issue with cdata

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 109136
interpreted = N
texte = --f46d0418264ce4255c04c0f49992 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I have tried [url]ing the "value" the contents are the contents, so I can't get to them. Stuart wrote something about using xlst, though this is one feature I have never used, so I have to play around with it.. there was another solution with a custom convert table which I will also try. Thanks for the input. d. On Sat, May 26, 2012 at 11:56 AM, D Brooke wrote: > Hi David, > > Not having time to read your entire issue... Should you [url] the '[]'s i= n > '[CDATA... ]'? > > > > D. Brooke Mobile > > On May 26, 2012, at 10: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 --f46d0418264ce4255c04c0f49992 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I have tried [url]ing the "value" the contents are the contents, = so I can't get to them. Stuart wrote something

about using xlst, though this is one feature I have never used, so I have t= o play around with it..

there was another solution with a custom con= vert table which I will also try.

Thanks for the input.

d.


On Sat, May 26, 2012 at 11:5= 6 AM, D Brooke <dbrooke@euca.us> wrote:
Hi David,=A0

Not hav= ing time to read your entire issue... Should you [url] the '[]'s in= '[CDATA... ]'?



D. Brooke Mobile

On May 26, 2012, at 10:35 AM, David Bastedo= <david@10plus1.c= om> wrote:

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

The node: =A0 <text><![CDATA[RT @BoyTopi: I want= to feel snow! Not the fake ones at Snow City.]]></text>
=A0I can see the content I want in an xml file. in the CDATA abvoe - being th= e content of a tweet "RT @BoyTopi: I want to feel snow! Not the fake o= nes at Snow 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



--


--f46d0418264ce4255c04c0f49992-- 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)
--f46d0418264ce4255c04c0f49992 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I have tried [url]ing the "value" the contents are the contents, so I can't get to them. Stuart wrote something about using xlst, though this is one feature I have never used, so I have to play around with it.. there was another solution with a custom convert table which I will also try. Thanks for the input. d. On Sat, May 26, 2012 at 11:56 AM, D Brooke wrote: > Hi David, > > Not having time to read your entire issue... Should you [url] the '[]'s i= n > '[CDATA... ]'? > > > > D. Brooke Mobile > > On May 26, 2012, at 10: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 --f46d0418264ce4255c04c0f49992 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I have tried [url]ing the "value" the contents are the contents, = so I can't get to them. Stuart wrote something

about using xlst, though this is one feature I have never used, so I have t= o play around with it..

there was another solution with a custom con= vert table which I will also try.

Thanks for the input.

d.


On Sat, May 26, 2012 at 11:5= 6 AM, D Brooke <dbrooke@euca.us> wrote:
Hi David,=A0

Not hav= ing time to read your entire issue... Should you [url] the '[]'s in= '[CDATA... ]'?



D. Brooke Mobile

On May 26, 2012, at 10:35 AM, David Bastedo= <david@10plus1.c= om> wrote:

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

The node: =A0 <text><![CDATA[RT @BoyTopi: I want= to feel snow! Not the fake ones at Snow City.]]></text>
=A0I can see the content I want in an xml file. in the CDATA abvoe - being th= e content of a tweet "RT @BoyTopi: I want to feel snow! Not the fake o= nes at Snow 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



--


--f46d0418264ce4255c04c0f49992-- 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:

Rollovers (1999) WCS Newbie question (1997) Bug Report, maybe (1997) RequiredFields template (1997) Dummy Credit Card Number for debug? (1997) taxRate is fine but taxTotal isn't (1997) Lost and Recovered. (1998) ShipTotal Yet Again (1998) format crash! (1997) Frames and WebCat (1997) Num Sort Descending (2004) Webcat 4.0.1b2 on ftp - what does it fix? (2000) Artwork (1997) Fun with Dates - revisited (1997) syntax question, not in online refernce (1997) Emailer (WebCat2) (1997) WebCat2 beta 11 - new prefs ... (1997) Preserving file creation dates on [copyfile] (2007) Encyption mail was Suggestions for Topics ... (1998) WebDNA and ASP on Same Server (2004)