Skip to Content
avatar image
Former Member

Left Justify a Concatenate Formula

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 14, 2017 at 10:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded