Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Extract XML from CLOB
 Login/Join
 
slfmr
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, 2005Report This Post
slfmr
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, 2005Report This Post
Waz
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.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
WF_IL
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, 2005Report This Post
slfmr
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, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders