AnsweredAssumed Answered

Padding string with spaces in NSQL Portlet

Question asked by bfarquhar on Feb 17, 2012
Latest reply on Apr 12, 2012 by bfarquhar
I'm hoping someone has tried this before and can share how to do it. I'm trying to pad the beginning of a string... in this case project name... with spaces to indent them. Something similar to this but without all the periods to pad it. I want white space.

WHEN proj_summary.INV_LEVEL = 1 THEN '. . . '+ proj_summary.PARENT_NAME
WHEN proj_summary.INV_LEVEL = 2 THEN '. . . . . ' + proj_summary.PARENT_NAME
WHEN proj_summary.INV_LEVEL = 3 THEN '. . . . . . . ' + proj_summary.PARENT_NAME
WHEN proj_summary.INV_LEVEL = 4 THEN '. . . . . . . . . ' + proj_summary.PARENT_NAME

The problem is that when rendered in the portlet it collapses the spaces. Does anyone know of any special characters or code that I could put in my NSQL that clarity will render as non-collapsing white space ?

Any help with this would be greatly appreciated !!!

Thanks,
Ben

Outcomes