Add multiple blank spaces between a string

mzlee

Hello, I am looking to concatenate columns into one string but I also need to format it with multiple spaces in between

Example:

Column 1 Column 2 Column 3

2835 2900 0000A2

I need the string to look like below, having a fix amount of blank spaces in between:

2835 2900 0000A2

thx!

Workflow

Accepted answers

Luke_C

@mzlee

This should work assuming columns 1 and 2 are always 4 characters. padright(tostring([Column 1]),10,' ') + padright(tostring([Column 2]),14,' ') + [Column 3]

All comments

Deano478

@mzlee How many fixed spaces do you need?

Luke_C

Hi @mzlee

Assuming you're outputting to a fixed width file you could try something like this with the padright function:

padright(tostring([Column 1]),14,' ') + padright(tostring([Column 2]),21,' ') + [Column 3]

This thread may also help you: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Create-a-fixed-width-output-using-layout-file/td-p/565646

mzlee

I need 6 fixed spaces between Column 1 and Column 2, and 10 fixed spaces between column 2 and Column 3

Luke_C

Hi @mzlee

Is that 6 and 10 no matter the length of the data in the column originally?

mzlee

Hi Luke,

Yes, should be a fixed length as well of 30 characters. Sorry for not adding that information on my initial question!

Luke_C

@mzlee

This should work assuming columns 1 and 2 are always 4 characters. padright(tostring([Column 1]),10,' ') + padright(tostring([Column 2]),14,' ') + [Column 3]

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703