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:

Deleting Orders (1997) Quick Question (1997) multiple search commands (1997) POS (2000) WebCatalog and Dreamweaver (1999) Help name our technology! (1997) Locking up with WebCatalog... (1997) RE: Web*SSL and WebCatalog (1997) Emailer port change (1997) [WebDNA] Grep everything and replace with asterisks? (2010) [WebDNA] DNA suffix (2008) Summing Fields (1998) Request Time Out (1997) using a link like http://www.domain.com/username (2000) WebCatalog can't find database (1997) Nested tags count question (1997) WebCatalog Technical Reference (1997) Re:no [search] with NT (1997) Date format problems (1997) PCS Frames (1997)