Skip to Content
0

Left Justify a Concatenate Formula

Feb 13, 2017 at 05:32 PM

22

avatar image

Is there a way to left justify a concatenated formula?

I have a formula that combines three fields

{Contract} & ' ' & {Description} & ' ' & {Name}

the problem I am running into is that description varies in length

I am try to get the Name field left justified on the longest description

i.e.

contract description name

contract descr name

contract descript name

etc.

I have tried the following but I still cannot get the third field to be left justified off the longest description.

Formula A

{Description} + replicatestring (" ", 65 - len ({Description})) + {Name}

Formula B

{Contract} & ' ' & @FormulaA

Thanks in advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Feb 14, 2017 at 10:01 AM
0

Sorry I do not understand what you are trying to achieve, in the layout you have shown the third field is left justified.

when you concatenate the fields like this {Contract} & ' ' & {Description} & ' ' & {Name} they are automatically left justified relative to each other.

Please show us what you are getting and what you would like to achieve.

Ian

Share
10 |10000 characters needed characters left characters exceeded