Formatting Strings 1

[ganjass]

CR8

Hi I need to format strings of a certain length, which is fine. But how would i go about padding the string to the max length if the string is below the max length. eg the max length it 40 and the string is 20, how would i pad it out with spaces

Cheers

 

[bdreed35]

This will work in 8.5 and should work in v8.

@Pad out field

whileprintingrecords;
numberVar MaxLength := 40;  //replace with your max

If Length({table.field}) < MaxLength then
    {table.field} + Space(MaxLength - Length({table.field}))
Else
    Left({table.field},MaxLength)

~Brian