How to add empty spaces after word into a 20 characters field?

Question

Hi all!

I have a TXT template in which I need to substitute "NNNNNNNNNNNNNNNNNNNN" for the name of cities, respecting empty spaces.

So for example:

New YorkNNNNNNNNNNNNNNNNNNNN

Bold where the word is and not bold the empty spaces.

Another example:

Philadelphia NNNNNNNNNNNNNNNNNNNN

Unfortunately, when I create the automation. the empty spaces that were not used are deleted from the file. My system only reads line with 241 positions on a TXT, so I need those empty spaces in there to fill the field "City" that I added "N's"

Very tough to explain, hope someone can enlighten me on this, it's been a few days I'm stuck on this.

I am adding one wrong output and the correct one, how it should be!

Thanks

Wrong output.txt

Template File.txt

Correct Output.txt

Automation Template.yxmd

Spainey · Accepted Answer

Hi @Joker_Hazard,

I think the issue is with your PadRight() function. It is the correct function to use, but the syntax is slightly wrong.

PadRight([City 20 characters], 20, '')

should be replaced with

PadRight([City 20 characters], 20, ' ') // Pad with a space character