Nov 18
Peter D Bethke XML extraction - 8.6
Nov 18, 2014; 16:26
Peter D Bethke
XML extraction - 8.6
Hello All,
I=92m working on a project with heavy XML parsing from an external SQL Server DS (via a REST service).
I=92ve been able to tackle most aspects of the back and forth but I=92m struggling to work with a kind of XML entity that contains fields within the tag itself.
Instead of:
<userrecords>
<userrecord>
<recordID>1234</recordID>
<name>Fred</name>
<state>Texas</state>
</userrecord >
<userrecord>
<recordID>5678</recordID>
<name>Ralph</name>
<state>Montana</state>
</userrecord>
<userrecord>
<recordID>91011</recordID>
<name>George</name>
<state>Virginia</state>
</userrecord>
</userrecords>
I=92m looking at:
<userrecords>
<userrecord recordID==931234=94 name==93Fred=94 state==93Texas=94>
<userrecord recordID==93 5678=94 name==93 Ralph=94 state==93Montana=94>
<userrecord recordID==93 91011=94 name==93 George=94 state==93Virginia=94>
</userrecords>
I=92m using the XML tags in 8.6 and having trouble figuring out how to extract the records seen in the second example. I can get their value as one chunk of text using ->ExtractOne, but I can=92t figure from there how to get them to be recognized as 3 separate records as might be done in the first example with ->Extract.
Any help would be most appreciated!
Best,
Peter
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Nov 18
Steve Piercy - Website Builder Re: XML extraction - 8.6
Nov 18, 2014; 13:29
Steve Piercy - Website Builder
Re: XML extraction - 8.6
Nov 18
Peter D Bethke Re: XML extraction - 8.6
Nov 18, 2014; 16:38
Peter D Bethke
Re: XML extraction - 8.6
Nov 18
Marc Vos Re: XML extraction - 8.6
Nov 18, 2014; 22:39
Marc Vos
Re: XML extraction - 8.6
Nov 19
Rick Draper RE: XML extraction - 8.6
Nov 19, 2014; 07:43
Rick Draper
RE: XML extraction - 8.6
Nov 18
Mason Miller Re: XML extraction - 8.6
Nov 18, 2014; 16:43
Mason Miller
Re: XML extraction - 8.6
Nov 18
Jolle Carlestam Re: XML extraction - 8.6
Nov 18, 2014; 22:48
Jolle Carlestam
Re: XML extraction - 8.6
Nov 19
Rick Draper RE: XML extraction - 8.6
Nov 19, 2014; 07:58
Rick Draper
RE: XML extraction - 8.6
Nov 19
Ke Carlton Re: XML extraction - 8.6
Nov 19, 2014; 12:02
Ke Carlton
Re: XML extraction - 8.6
Nov 19
Peter D Bethke Re: XML extraction - 8.6
Nov 19, 2014; 10:37
Peter D Bethke
Re: XML extraction - 8.6