Display two fields in a column. The second field starting after 30 characters

HCL Domino Domino Forum
1

I have a categorized column in which I like to display 2 fields. I did it this way:Field1 + " (" +Field2+ “)”

Problem it looks not that well, because the Field1 content has different number of characters/letters. I would like to have the field2 starting e.g. after 30 characters. It should look like having used a tab in MS Word …

My idea is to use a font like MS line draw (identical space width) and count the charakters in field1 and than add the ‘missing’ number of characters as blanks to it, so that the field2-text starts after 30 characters.

Is this nonsense or possible?

Thank you for your help in advance

Leini

2

Subject: Display two fields in a column. The second field starting after 30 characters

Leini,

You can certainly do it, and I imagine one of the other responses gives a formula that will work for you. I’ve done this before, but always ended up canning the idea because the monospaced fonts just look so miserable in a gui application.

just my 2c,

raphael

3

Subject: Display two fields in a column. The second field starting after 30 characters

Make blanks 30 spaces.

blanks := " ";

Field1 + @Left(blanks; 30 - @Length(Field1)) + " (" +Field2+ “)”

4

Subject: Display two fields in a column. The second field starting after 30 characters

not tested but try something like this:

len := @Length(Field1);

dif := 30 - len;

spaces := @Repeat(" " ; dif);

Field1 + spaces + “(” +Field2+ “)”

5

Subject: Wonderful - Thanks …

Thank you for this formula - works exactly as I wanted to have it …Leini

6

Subject: Display two fields in a column. The second field starting after 30 characters

Don’t know how many documents you have in your view. Why don’t you create a computed hidden field for your first column field in your form and have a formula for it as:

ds := @If(@Length(Yourfield) < 30; @ReplaceSubstring(Yourfield; Yourfield; Yourfield+@Repeat(" ";30-@Length(Yourfield)-1)); Yourfield);

@Left(ds; 30);

This will make your first field with 30 characters. Now Concatenate it with your second field in the same column so that it looks like (without dashes ofcourse):

Firstfield--------------------SecondField

Descriptionfield-------------SecondField

Smtfield---------------------SecondField

Make sure you run an agent to fill the computed field in each document of the view so that the new field will contain the value of the first field upto 30 characters with added spaces.

or you can have this in the actual field of InputTranslation event and make sure you trim this field, if you are using elsewhere.