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] handle Control Chars
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] handle Control Chars
 Login/Join
 
Silver Member
posted
Hi,

I have small issue with my Stored Procedure Output.
My SP returns multiple description columns and some of them have the control characters. When I print &Lines it shows more than the actual number of rows because it break the rows when it find control char and counting as new line.

Anybody have idea?

Thank You
Sandya

This message has been edited. Last edited by: <Kathryn Henning>,
 
Posts: 46 | Registered: December 06, 2011Reply With QuoteReport This Post
Expert
posted Hide Post
If you can identify the offending control characters, then you can use CTRAN, or other functions, to change the control characters to something else (maybe nulls?)...
 
Posts: 3052 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Are the control characters stored in the data in the DB? Should they be there? What it sounds like is you get 'hard' carriage returns which are a bit nasty indeed, and hard to catch.

You need to identify and filter them out - I'd say this needs to be done at the DB level or in the stored procedure output formatting.


Cheers,
H.

WebFOCUS 8.1.05M
Oracle 11g - DB2
RedHat
 
Posts: 114 | Location: Brighton UK | Registered: February 19, 2005Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks for your reply.

Yes these controls are stored in data in DB.
 
Posts: 46 | Registered: December 06, 2011Reply With QuoteReport This Post
Expert
posted Hide Post
Try the REPLACE function in the Stored Proc:
  
REPLACE ((REPLACE ((REPLACE (substr(t6.scbdesc_text_narrative, 1,6000), CHR(13),'')), CHR(10),'')),';','') text_narrative,

Example


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1961 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] handle Control Chars

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