[CLOSED] Text Formatting

You'll have to use some of these functions in a DEFINE to accomplish this.
https://webfocusinfocenter.inf...cterSimplified70.htm

WebFOCUS 8206, Unix, Windows

Posts: 1853 | Location: New York City | Registered: December 30, 2015

Ignored post by BabakNYC posted

Waz

Expert

posted

Whats the output format ?

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	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, 2006

Ignored post by Waz posted

Master

posted

quote:
Originally posted by Waz:
Whats the output format ?

Agreed. In order to answer this, we need to know what the output will be, since outputs have different answers.

There is probably a better way to do this, but this COMPUTE with nested functions works for HTML

  
-SET &TEXT = '==Prepare Muffins==>>Get the flour>>Get the sugar>>Find some berries==Bake The Muffins==>>set oven to 350>>grease a pan>>place muffins in oven>>set timer for 40 min';

TABLE FILE CAR
PRINT COMPUTE NEWFIELD/A200V = SUBSTRING(REPLACE(REPLACE(REPLACE(&TEXT.QUOTEDSTRING,'>>','<br>>>'),'==','<br>=='),'<br>==<br>>>','==<br>>>'),5,200);
BY COUNTRY NOPRINT
WHERE COUNTRY EQ 'ENGLAND'
ON TABLE SET PAGE-NUM NOPAGE
END

Hallway

Prod: 8202M1

Test: 8202M4

Repository:

OS:

Outputs:

Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015

Ignored post by Hallway posted

Master

posted

In JavaScript you can use the replace function using a regular expression. Copy/paste this code into the console of any modern browser (And no, IE is not a modern browser)

 
var oldText = '==Prepare Muffins==>>Get the flour>>Get the sugar>>Find some berries==Bake The Muffins==>>set oven to 350>>grease a pan>>place muffins in oven>>set timer for 40 min'
var newText = oldText.replace(/(?<=[a-z])={2}(?!>)|>{2}/g, '\n$&')
console.log(newText);

That will return the following to the console:

 
==Prepare Muffins==
>>Get the flour
>>Get the sugar
>>Find some berries
==Bake The Muffins==
>>set oven to 350
>>grease a pan
>>place muffins in oven
>>set timer for 40 min

Hallway

Prod: 8202M1

Test: 8202M4

Repository:

OS:

Outputs:

Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015

Ignored post by Hallway posted

Member

posted

Thanks for the replies. PDF is my output. What is my bet option then?

Thank you!

Posts: 17 | Registered: April 18, 2019

Ignored post by DataCarniv0r posted

Tony A

Expert

posted

Welcome DataMuncher,

Use Hallways first method but use HEXBYT(10,'A1') to insert a linefeed character instead of the the HTML breaks ( <br> ) then use LINEFEED='LF' within the styling.

Linefeed can be found in the help files here

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Member

posted

Sorry, just made a discovery. The carriage returns and line feeds are coming across fine in the SQL field I'm using. For example, when I copy that text from Oracle SQL Developer to Notepad, I can see the format as intended. Is there a way I can tell the field in App Studio to just observe the CRs and LFs that are stored in the text field?

Posts: 17 | Registered: April 18, 2019

Ignored post by DataCarniv0r posted

Tony A

Expert

posted

Yes, use the LINEFEED syntax within your styling. You need to have consistant characters in your data or just take a punt and specify just LINEFEED=CR or LINEFEED=LF.

This should be found in the documentation link that I gave.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Master

posted

quote:
Originally posted by DataCarniv0r:
Thanks for the replies. PDF is my output. What is my bet option then?

Thank you!

This works:

 
-SET &TEXT = '==Prepare Muffins==>>Get the flour>>Get the sugar>>Find some berries==Bake The Muffins==>>set oven to 350>>grease a pan>>place muffins in oven>>set timer for 40 min';

DEFINE FILE CAR 
NEWFIELD/A200V WITH COUNTRY = SUBSTRING(REPLACE(REPLACE(REPLACE(&TEXT.QUOTEDSTRING,'>>', CTRLCHAR(CR) | CTRLCHAR(LF) | '>>' ),'==', CTRLCHAR(CR) | CTRLCHAR(LF) | '=='),CTRLCHAR(CR) | CTRLCHAR(LF) |'=='|CTRLCHAR(CR) | CTRLCHAR(LF) |'>>','=='| CTRLCHAR(CR) | CTRLCHAR(LF) |'>>'),3,200);
END
TABLE FILE CAR
SUM NEWFIELD
ON TABLE PCHOLD FORMAT PDF
-* ON TABLE NOTOTAL
-* ON TABLE SET DROPBLNKLINE ALL
-* ON TABLE SET PAGE-NUM NOPAGE
-* ON TABLE SET CACHELINES 100
-* ON TABLE SET GRWIDTH 1
-* ON TABLE SET AUTOFIT OFF
ON TABLE SET STYLE *
TYPE=REPORT,LINEBREAK='CRLF',$
ENDSTYLE
END

More here: CTRLCHAR: Returning a Non-Printable Control Character

Hallway

Prod: 8202M1

Test: 8202M4

Repository:

OS:

Outputs:

Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015

Ignored post by Hallway posted

Master

posted

quote:
Originally posted by Tony A:
Yes, use the LINEFEED syntax within your styling. You need to have consistant characters in your data or just take a punt and specify just LINEFEED=CR or LINEFEED=LF.

This should be found in the documentation link that I gave.

T

or if there is a CR and a LF, try:

 
TYPE=REPORT,LINEBREAK='CRLF',$

Syntax: How to Display An and AnV Fields Containing Line Breaks on Multiple Lines

TYPE=REPORT,LINEBREAK='type',$

where:

REPORT

Is the type of report component. TYPE must be REPORT. Otherwise an error will result.

'type'

Specifies that line breaks will be inserted in a report based on the following:

LF inserts a line break after each line-feed character found in all An and AnV fields.

CR inserts a line break after each carriage-return character found in all An and AnV fields.

LFCR inserts a line break after each combination of a line-feed character followed by a carriage-return character found in all An and AnV fields.

CRLF inserts a line break after each combination of a carriage-return character followed by a line-feed character found in all An and AnV fields.

More Here: Displaying Multi-Line An and AnV Fields

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

Hallway

Prod: 8202M1

Test: 8202M4

Repository:

OS:

Outputs:

Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015

Ignored post by Hallway posted

Member

posted

Thank you both very much. It works like a champ, but now I have a new problem.

This works: I created a computed column using:
CTRAN(1000, MY_SQL_FIELD, 094, 013, Funding)

Then I added this to my source within the style section as per the docs:
TYPE=REPORT,LINEBREAK='CR',$

When I run it, it looks exactly as expected. I saved it. But when I switch to the Design tab, and then back to the Source tab, the TYPE=REPORT,LINEBREAK='CR',$ line I put in there is gone!

Is this a known issue or is there any workaround I can do?

Thanks

Posts: 17 | Registered: April 18, 2019

Ignored post by DataCarniv0r posted

Member

posted

I guess I could just add that line back in the source when I'm done with the entire report, and then save it. Not a big deal. Thanks again.

Posts: 17 | Registered: April 18, 2019

Ignored post by DataCarniv0r posted

Master

posted

quote:
Originally posted by DataCarniv0r:

When I run it, it looks exactly as expected. I saved it. But when I switch to the Design tab, and then back to the Source tab, the TYPE=REPORT,LINEBREAK='CR',$ line I put in there is gone!

Is this a known issue or is there any workaround I can do?

Thanks

There are a lot if issues with AppStudio reformatting/replacing code in the GUI. It get frustrating at times when the GUI doesn't even recognize valid FOCUS code like you are experiencing. If I ever use the GUI it is just to get the basic report laid out. I then open the report in VSCode (or any other text editor you may prefer) and edit the code in that if I need to do any tweaks.

Good luck.

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

Hallway

Prod: 8202M1

Test: 8202M4

Repository:

OS:

Outputs:

Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015

Ignored post by Hallway posted