Hello,
Please help me figure out how I can format text in an Interactive Grid plain text field. I do have a column fetched from a table in an Interactive Grid column. The column in a table is a varchar2 type and has the text of up to 1000 characters. Now the requirement of an Interactive Grid is, that I want to display it in a bullet format if it has multiple sentences separated by '.'
Example:
Actual: Suzy provides the monthly financial reporting based on provided figures. The shareholders of the store have changed effective November 2021.
How I want:
Suzy provides the monthly financial reporting based on figures.
The shareholders of the store have changed effective November 2021.
Note: I have tried the solution by adding "replace(comments, '.', '<br>') comments" in select query in an interactive grid but it isn't working.
Many Thanks,
Bansari
APEXUSER (nobody)
Hey! Hope u are doing great...
Use Your Same Function
replace(comments, '.', '<br>')
Go to Column Property and Disable this option
"Escape special characters"
Thanks!