inserting a line break in table box

[diwaskarki]

Hi,

I am displaying a string field in a table box.String is really long and is delimited by a '||'. I tried using a replace function to replace '||' with chr(10) which is a line break but this displays only one row in the table.

Is there an expression I can use to replace '||' with a line break? I would really appreciate it. 

[el_aprendiz111]

Hi,

=replace('abecdfgg ||| asasdas || d dsfsdf|', '|', chr(13))

[diwaskarki]

hello Jairo,

why do you have multiple '|||' and why do you have several string segments?

[vishsaggi]

May be use Subfield() Function like

LOAD yourfieldlist,

          Subfield([Removed Roles], '||') AS NewColName

FROM yoursource;

Then use this NewColName in your table box.

[sasiparupudi1]

Try

replace(YourField, '||', Chr(10)&chr(13))

[bhaskar_sm · Accepted solution]

Hi,

Please find attached the Solution Qvw.

use the Chart Property-> Presentation-> check the Wrap Cell Text->enter 7

if you found this helpful, please mark as helpful or correct.

Regards,

Bhasker