Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Extract XML from CLOB
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Extract XML from CLOB
 Login/Join
 
Platinum Member
posted
I've seen quite a few posts on this, but a lot of them seem unanswered.

I know how to pull the contents of a CLOB but what my problem is, is that it is removing the tags which I want.

So:

(ignore all spaces in the below lines, i had to do it because even here the tags were removed)

< Employee > Joe < /Employee >< PhoneNumber > 111-222-4444< / PhoneNumber >

is coming back as:

Joe111-222-4444

I actually need to keep the tags. Also I don't know what tags will be in the clob so I can't search for it then append it later.

Any thoughts on how to have webfocus bring back the xml tags?

This message has been edited. Last edited by: Kerry,


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
 
Posts: 178 | Registered: May 11, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
So what I ended up doing was this (if anyone needs the same info):


-SET &RPLC = '< B>&' || 'lt;< /B>'; (with no spaces after the < )

Then did a replace in sql on my output:

replace (myfield, '<', '&RPLC')

and that printed fine so that it is not a < but an '& lt;' [again no spaces) with break tags.


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
 
Posts: 178 | Registered: May 11, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
Was this an HTML report ?

If so, the tags will be interpreted as HTML tags, and removed.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6105 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi

If you have the XML schema (xsd) for the XML and you are also licensed to the Webfocus XML adaptor you could report directly against the CLOB field, each XML tag would become a field in the master file.
This is documented in the adaptors manual,under the XML adaptor, How to Access XML Data From an RDBMS .

(You create a master file against the xml document using xsd or directly against the XML itself and then combine it with the master you created against the Oracle table which contains the CLOB field )


Yours,
Eran
SRL Products

http://www.srl.co.il

 
Posts: 97 | Location: Tel Aviv, Israel | Registered: November 20, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
It was an excel report, but since it does create html first, I figured the same and replace the actual tag with the almost spelled out version.

We don't have the xsd or the adaptor license at this time, but that is something to look in to for the future.

Thank you


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
 
Posts: 178 | Registered: May 11, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Extract XML from CLOB

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.