Friday, 22 June 2012

Line Break in the column

We need to display the text inside the column formula with a line break to show the data broken with horizontal pieces.
So as always we can call HTML into rescue for such situation. And also to mention OTN serves good to come up with different ideas meeting the requirements.

We can replace the words blank spaces with a <br> tag like the one shown below-

Replace('Good Day To People',' ','<br>')

Result for the above code in the column formula-

The above piece of code holds good in the situtation where there is a line break after every space.

Supposing if we need to have a line break after few sets of words then the code should be like the below-

Replace('Good Day* To People Out* There','* ','<br>')

And the last piece of code without the Replace statement-


I used the below code to display the values as


NOTE- Please dont forget to change the Data format of the column in the column properties to 'HTML'


  1. Hi,

    Can we use this syntax Replace('Good Day To People',' ','
    ') in column prompt?

  2. Can we use this before a custom formula, because when I tried using it both with replace and concat function, it gave me an error "Formula syntax is invalid.
    [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 22020] Function Concat does not support non-text types. (HY000)"

    Before the formula, for example:
    'Role Model Expert' ||'
    '||(COUNT(CASE WHEN (CASE WHEN (CASE WHEN "Profile Job Preferences"."Profile Experience - Years of Management" = 0 THEN 'N/A' WHEN "Profile Job Preferences"."Profile Experience - Years in Industry" > 0 AND "Profile Job Preferences"."Profile Experience - Years in Industry" <= 1 THEN 'Low'.

    Also, in data format I am unable to find the HTML format when I write this with custom formula.


Thanks to Comment