I have to print a field which is having 70 size but I don’t have space to print it in the PDF file.

Is there any way to split that into 2 strings may be each one size 35 (without splitting the word), So that I can print one below the other?

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

Yes you can, but how about wrapping the field?

I want to split at the 3rd space.

like the below

full text: Test Program for focus program
line1/35 = Test Program for
line2/35 = focus program

You can solve it in many ways.

I would use wrap (do a search on it) but you can create two new fields with the formula EDIT or SQUEEZ or SUBSTRING.

locate the position of your 3rd blank (use the POSIT function and SUBSTR function, or some folks are fans of the GETTOK function...all in your *Using Functions* manual ),
then replace that 3rd space as follows:

DEFINE FILE CAR
CR/A1 = HEXBYT(13, 'A1');
LF/A1 = HEXBYT(10, 'A1');
CRLF/A2 = CR || LF;
-* if your output is PDF or ELX2K
ABC5/A30=CAR || CRLF || COUNTRY;
-* if your output is onscreen ABC5/A100='<table><tr><td>'|CAR|'<br>'|COUNTRY|'</td></tr></table>';
END
-RUN
TABLE FILE CAR
SUM ABC5 BY CAR BY COUNTRY
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,LINEBREAK='CRLF'
ENDSTYLE
END
-RUN

i got this hexbyte combo from my colleagues on focal point, i'm sorry i can't remember from whom, but if you do a search on 'HEXBYT(13' you'll come up with several references.

Susannah,

Very nice. Now how do you do something similar if you want the fields to be right-justified?

Jagan, is this field to be split, a column in the report or part of a heading/footing?