Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
Hi
Try like this,
IF(len([Profile Identifier]) < 18 , [Profile Identifier]&Repeat(' ',18-len([Profile Identifier])),[Profile Identifier])
Hope it helps
Hi
Try like this,
IF(len([Profile Identifier]) < 18 , [Profile Identifier]&Repeat(' ',18-len([Profile Identifier])),[Profile Identifier])
Hope it helps
Thank you! that was perfect!!!