Thursday, January 24, 2019

How to display empty spaces on Saved Search Results

Currently, Saved Searches truncate all empty/null spaces when user are tryingto output a string. For example, if you add Formula(Text) = 'a      b'with 6 spaces in between 'a' and 'b', then the system will return 'a b' withonly one space. The solution is to convert the '&nbsp' to a character.

To illustrate:

Assume user want to show '                ITEM_NAME' with 16 spacesbefore the Item Name where Item Name = ITEM_NAME. Then, you canuse the formula: LPAD({name}', length({name})+16,to_char(' ')).

Initially when you user the Saved Search it will show:&nbspITEM_NAME. Just hit Return toCriteria, and the '&nbsp'will be converted to ' '.

No comments:

Post a Comment