Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

DB Rule line return

Highlighted
Jessica Rinaldi
Acclaimed Contributor

DB Rule line return

I am creating a database rule to concatinate a custom field with the text from the information field and I cannot figure out how to insert a line return in the value for conatenation. In other words... in the Fixed value field for the database rule is there a way to insert/code a line return? I would like there to be a separator like "- - - - -" and then a line return to the next line for the concatinated text from the information field so that it isn't all on one line.
4 REPLIES
George M. Meneg
Honored Contributor

Re: DB Rule line return

Hello Jessica,

Either right click on the label "Fixed value" and select "Zoom in..." or double click on the label "Fixed value". It will open a new, multi-line box where you can instert CRs
menes fhtagn
SDSKonline
Regular Collector

Re: DB Rule line return

Hi,

What if I want to insert an empty space between values?

' ', " " -> are interpreted as text strings

an empty space in the Value field returns an error, saying the field is empty, when I press OK...

Any solution?
Craig R Taylor
Collector

Re: DB Rule line return

The text you need to enter as a value for a line separator is %line.separator% Does anyone know of any more such values?
You can observe a lot just by watching. - YOGI BERRA
SDSKonline
Regular Collector

Re: DB Rule line return

Well, I know that about the 'new line'. My question is about a simple blank space.
//Add this to "OnDomLoad" event