Solved: How to prevent leading spaces being clipped?

MichaelQ

I have a text attribute that contains leading spaces for formatting purposes.
How can I prevent them automatically being clipped when displayed in a query?

Thank you.

MichaelQ

Anyone?

Jaymer

what if you had a 2nd field (Field2) that was always initialized to your desired field.
Field2 is a type HTML.
You do a REPLACE (or whatever) to change leading spaces to  
Display this field in the query

jaymer...

aware_support

The TRIM function clips both leading and trailing spaces. Check it out.

MichaelQ

Thanks Jaymer.
I didn't understand what you meant by "Field2 is a type HTML". I couldn't find an HTML field type. So I just used a text attribute and added leading spaces using '  ' as you suggest, which worked!

Thanks Support.
I searched for 'TRIM' in the User Guide & Rule Language pdfs but couldn't find any reference to this function. Anyway Jaymer's solution worked.

Jaymer

glad that worked

the HTML is an option for FORMAT on a Plain Text field. (see pic)

I was suggesting you'd have a rule to pad with the blanks. In this example, I just typed this in using the HTML formatter.

Here's how it would look in a Query

Jaymer

Here is whats stored in the database for the HTML field:

MichaelQ

Thank you.
This solution raises a question about programming elegance.

I am displaying a nested hierarchy by padding spaces using a 'TreeDepth' attribute which may be 0-9. Currently I have to write a rule for each level like this (each level is indented by 4 spaces):

If Item.TreeDepth=1 Then
Item.Name4Tree='    '+Item.Name

Is there a way that I could write one rule which will add the required number of spaces according to the TreeDepth?

MichaelQ

I figured out how to compose this action more concisely so that each level in the hierarchy is indented by an additional 6 spaces:

Item.Name4Tree=''
Item.Name4Tree=PAD_LEFT(Item.Name,' ',Item.TreeDepth*6+LENGTH(Item.Name))