Focal Point
[CLOSED] MERGE AND CENTER DATA

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5867009986

April 12, 2018, 04:30 AM
jenni
[CLOSED] MERGE AND CENTER DATA
Hi,

I want to write 1 field into many rows, wich are empty sothat from:

|whatever |text which is too Long-|--------|--------|
|whatever |whatever---------------|whatever|whatever|
|whatever |whatever---------------|whatever|whatever|
|whatever |whatever---------------|whatever|whatever|

to:
|whatever |text which is too Long-----|
|whatever |whatever-|whatever|whatever|
|whatever |whatever-|whatever|whatever|
|whatever |whatever-|whatever|whatever|

So, the one field wich is too Long for this one row field and does not look nice, is now "merged and centered" over many rows.

It's not a heading!!
And is Needs to be PDF, not Excel.

Hope there is a Chance..

Thanks

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.1.05
Windows, All Outputs
April 12, 2018, 06:52 AM
Frans
Do you mean you want to write one field into multiple columns?


|whatever |text which is too Long-----|whatever|whatever|
|whatever |whatever-|whatever|whatever|
|whatever |whatever-|whatever|whatever|
|whatever |whatever-|whatever|whatever|

Multiple rows would look like this
|whatever |text whic|whatever|whatever|
h is too
Long-----
|whatever |whatever-|whatever|whatever|
|whatever |whatever-|whatever|whatever|
|whatever |whatever-|whatever|whatever|

Is a subheading an option?


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
April 12, 2018, 07:27 AM
jenni
YES, I want to write one Long text into multiple column, like the Option merge and Center in Excel.

Or I want to split my tables into two seperated ones and put them in a Ducment together, the Problem is, (because page break) there are several pages and they don't stay in place


WebFOCUS 8.1.05
Windows, All Outputs
April 18, 2018, 11:38 AM
FP Mod Chuck
Jenni

If this is still an issue then I suggest you open a case with techsupport..


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
April 18, 2018, 02:07 PM
RSquared
To split a long field into shorter ones
1) Insert a ‘break’ character into the lines

COMMENT_PARA/A1024V=PARAG(1024, COMMENT, '|', 70, COMMENT_PARA);

2) Create the required number of lines.


COMMENT1/A70=GETTOK (COMMENT_PARA, 1024, 1, '|', 70, COMMENT1);
COMMENT2/A70=GETTOK (COMMENT_PARA, 1024, 2, '|', 70, COMMENT2);
COMMENT3/A70=GETTOK (COMMENT_PARA, 1024, 3, '|', 70, COMMENT3);
COMMENT4/A70=GETTOK (COMMENT_PARA, 1024, 4, '|', 70, COMMENT4);
COMMENT5/A70=GETTOK (COMMENT_PARA, 1024, 5, '|', 70, COMMENT5);
COMMENT6/A70=GETTOK (COMMENT_PARA, 1024, 6, '|', 70, COMMENT6);
COMMENT7/A70=GETTOK (COMMENT_PARA, 1024, 7, '|', 70, COMMENT7);
COMMENT8/A70=GETTOK (COMMENT_PARA, 1024, 8, '|', 70, COMMENT8);
COMMENT9/A70=GETTOK (COMMENT_PARA, 1024, 9, '|', 70, COMMENT9);


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit