Trying to figure out a way in WebFOCUS on the Synonym or on ...

[Kristi Carter]

Trying to figure out a way in WebFOCUS on the Synonym or on the report itself for an HTML or AHTML format, how to force a new character line when the values of sun., org. or java. show.

TIBCO_ForceWrap_Sample.xlsx (179.5 KB)

[David Beagan]

You could use the REPLACE function to put in <br> tags. For example, to add line breaks after 'ADM' and 'MGR' in the SKILL_DESC field of ibisamp/jobfile.

TABLE FILE ibisamp/jobfile

PRINT

SKILL_DESC

COMPUTE SKILL_DESC2/A35 = REPLACE(SKILL_DESC, 'ADM', 'ADM'|'<br>');

COMPUTE SKILL_DESC3/A40 = REPLACE(SKILL_DESC2, 'MGR', 'MGR'|'<br>');

ON TABLE PCHOLD FORMAT AHTML

END

[Kristi Carter]

That is exactly what I was looking for. I just couldnt figure out the right syntax on the portion. This seems to be doing what I needed.

Thanks so much for the help.

Kristi

[David Beagan]

I glad it works for you.