

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
inserting a line break in table box
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.
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
=replace('abecdfgg ||| asasdas || d dsfsdf|', '|', chr(13))


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hello Jairo,
why do you have multiple '|||' and why do you have several string segments?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be use Subfield() Function like
LOAD yourfieldlist,
Subfield([Removed Roles], '||') AS NewColName
FROM yoursource;
Then use this NewColName in your table box.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
replace(YourField, '||', Chr(10)&chr(13))


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
