• ×
    Information
    Need Windows 11 help?
    Check documents on compatibility, FAQs, upgrade information and available fixes.
    Windows 11 Support Center.
  • post a message
  • ×
    Information
    Need Windows 11 help?
    Check documents on compatibility, FAQs, upgrade information and available fixes.
    Windows 11 Support Center.
  • post a message
Guidelines
Seize the moment! nominate yourself or a tech enthusiast you admire & join the HP Community Experts!
Archived This topic has been archived. Information and links in this thread may no longer be available or relevant. If you have a question create a new topic by clicking here and select the appropriate board.

‎08-15-2018 02:08 PM

HP Recommended
Product: HP SmartStream Designer 13
Operating System: Mac OS X 10.11 El Capitan

Hi, I need to create a rule where a line break needs to be concatenated if the expression evaluates to FALSE but I can't find a way to insert a line break in the advanced rule window. This is what my rule looks like:

 

IF(FIELD("Last")=FIELD("Spouse-Last"))

THEN(CONCAT(FIELD("First")," and ",FIELD("Spouse-First")," ",FIELD("Last")))

ELSE(CONCAT(FIELD("First")," ",FIELD("Last"),"\n", FIELD("Spouse-First")," ", FIELD("Spouse-Last")))

 

So what this does is the person's last name is the same as their spouse's last name it will show as: John and Jane Smith

If not is should look like this:

John Smith

Jane Doe

 

I thought that inserting \n would do the trick but instead it actually shows up in preview. i.e: John Smith\nJane Doe

Is there a way to do this?  I know I could have 2 rules setup in a way to acomplish this but I want to know if it's possible to insert line breaks and have only 1 rule. This has been bugging me for a while.  Thanks for the help!

Archived This topic has been archived. Information and links in this thread may no longer be available or relevant. If you have a question create a new topic by clicking here and select the appropriate board.
† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.
Didn't find what you were looking for? Ask the community
† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the <a href="https://www8.hp.com/us/en/terms-of-use.html" class="udrlinesmall">Terms of Use</a> and <a href="/t5/custom/page/page-id/hp.rulespage" class="udrlinesmall"> Rules of Participation</a>.