Focal Point
[CLOSED] Wrapping Long Text Fields with No Spaces

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

September 16, 2015, 09:25 AM
iBeny
[CLOSED] Wrapping Long Text Fields with No Spaces
I have field read_value which has values like:
1727101BDD00BAC20000DD01000002DD0232DD043FDD0542DD0666F4030101F40400F40540F40680F40780F40880F40980F40C0000F40D00F40E00F40F00F4100000F41129F42F09F44927F44A27FD9001FDA10000FDA300FDA45BFDA65B

I want to wrap this field but the wrap does not work because there are no spaces.

TABLE FILE SQLOUT
PRINT
SESSION_KEY AS 'Session'
TEST_TYPE AS 'Test,Type'
EXECUTION_SEQUENCE AS 'Execution,Sequence'
MODULE_ID AS 'Module,ID'
MODULE_TITLE AS 'Module,Title'
DATA_READ_NAME AS 'Data,Read Name'
READ_VALUE AS 'Value'
ON TABLE PCHOLD FORMAT HTML

There is no fixed pattern of the string, i cannot even use a Delimiter to insert a space using STRREP, Could anyone please suggest a possible work around?

This message has been edited. Last edited by: <Kathryn Henning>,


Webfocus 8105,8808,7703,7611, EXL2K,HTML,PDF,COMT,AHTML Info Assist+ , Reportcaster
September 16, 2015, 02:34 PM
Dan Satchell
One option is to use a text field and set the length of the field to the desired wrap length:

DEFINE FILE CAR
LONG_TEXT/TX50 WITH COUNTRY = 
'1727101BDD00BAC20000DD01000002DD0232DD043FDD0542DD0666F4030101F40400F40540F40680F40780F40880F40980F40C0000F40D00F40E00F40F00F4100000F41129F42F09F44927F44A27FD9001FDA10000FDA300FDA45BFDA65B';
END
-*
TABLE FILE CAR
PRINT COUNTRY LONG_TEXT
END



WebFOCUS 7.7.05
September 19, 2015, 10:05 PM
Jim Morrow
Hints:

1. investigate the PARAG function

2. Investigate "TEXT" field format


Jim Morrow
Web Focus 7.6.10 under Windows 2003
MVS 7.3.3