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     [CASE-OPENED] avoid line breaks in text field
Go
New
Search
Notify
Tools
Reply
  
[CASE-OPENED] avoid line breaks in text field
 Login/Join
 
Gold member
posted
I have a comments text field that can have up to 2gb data.
I need to print the comments text field like a paragraph.
Issue is when I print the text field, it breaks in to multiple lines with out being a one continuous big line.
From what I understand from the documentation
(from the documentation:Text fields can be used to store large amounts of data and display it with line
breaks.), text fields do display linebreaks in between the text.
Is there a way to avoid line breaks in the text field?
I do not want to split in to multiple fields and then display them because for 2GB worth of data, it will be too many fields to split.

Thank you.

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


7.7.01,windows2008 R2
 
Posts: 65 | Registered: July 28, 2011Reply With QuoteReport This Post
Master
posted Hide Post
quote:
I need to print the comments text field like a paragraph.
Issue is when I print the text field, it breaks in to multiple lines with out being a one continuous big line.

I don't understand. The second sentence seems to be exactly what you are looking for in the first sentence... And 2GB in one field is definitely a stretch. Others here, who are much smarter than me, will tell you precisely what the limits are. I suspect you are going to have to READ your text, word by word, from a file, and then re-concatenate the text in your report.


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Reply With QuoteReport This Post
Gold member
posted Hide Post
SET PAGE = NOPAGE
DEFINE FILE CAR
SAMPLE_TEXT/TX50= 'This is a test for Text field. Lines get broken in the middle of the page.  They are not continuous.  Any alternative for this?';
END
TABLE FILE CAR
BY COUNTRY NOPRINT SUBFOOT
"<SAMPLE_TEXT"
ON TABLE PCHOLD FORMAT DOC
END
-EXIT

Please run the above code. You would see what I mean. The sentence should have run through the entire length of the page instead of breaking in the middle.
I understand that it is because I defined the text field as TX50. Even I define it to max length of 256 characters, still the lines would break after 256 characters. Our users enter long text. So, TX256 is also not an option for me.

Thank you


7.7.01,windows2008 R2
 
Posts: 65 | Registered: July 28, 2011Reply With QuoteReport This Post
Virtuoso
posted Hide Post
The only way I know is to create the field as an A32000, Actual and Usage.

Bu that is the read limit, so I do not think that you will ever display more than just under 32k.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks Alan. That is exactly what I am doing currently. But, I was checking to see if there are any other alternatives.
I opened a case with IBI on this.
Wouldn't it be nice to be able to print the text field the way it is stored in the database?

Thanks.


7.7.01,windows2008 R2
 
Posts: 65 | Registered: July 28, 2011Reply With QuoteReport This Post
Virtuoso
posted Hide Post
TX fields are designed for displaying large amounts of text in paragraph form. The length you specify for the field determines the width of the paragraph. If you want Word to determine the width of the paragraph, then use an alpha field and let Word wrap the text where it wants. If the data is stored as TX, you can either increase the size (width) of the TX field or convert it to an alpha field in a DEFINE or COMPUTE:

DEFINE FILE CAR
 SAMPLE_TEXT1/TX50 = 'This is a test for Text field. Lines get broken in the middle of the page.  They are not continuous.  Any alternative for this?';
 SAMPLE_TEXT2/TX65 = SAMPLE_TEXT1 ;
 ALPHA_TEXT/A32000 = SAMPLE_TEXT1 ;
END
-*
TABLE FILE CAR
 BY COUNTRY NOPRINT SUBFOOT
  "<SAMPLE_TEXT1"
  " "
  "<SAMPLE_TEXT2"
  " "
  "<ALPHA_TEXT"
 WHERE RECORDLIMIT EQ 1 ;
 ON TABLE SET PAGE NOPAGE
 ON TABLE PCHOLD FORMAT DOC
END


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] avoid line breaks in text field

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