Add trailing spaces to value

[#1]

We need to add trailing spaces to values where the len() is less than 18.  Is this possible.

IF len([Profile Identifier]) < 18 

THEN

     add 18  - len(len([Profile Identifier])  SPACES to the end of the text([Profile Identifier])

As [Profile Identifier]

[MayilVahanan · Accepted solution]

Hi

Try like this,

IF(len([Profile Identifier]) < 18 , [Profile Identifier]&Repeat(' ',18-len([Profile Identifier])),[Profile Identifier])

Hope it helps

[#3]

Thank you!  that was perfect!!!