PadRight without Delimiter?

[rockeylearning]

Hi Community!

I built over 100 fields with fixed length in Alteryx workflow, and the output is a .txt file, how do I output it to where these fields are closed together without the tab or space delimiter?

For example, Field A length is 8, Field B length is 3,

the output in the .txt should be:

12345678ABC

I may be able to use concatenate but I don't know if that the right approach, and beside, since there are a lot of fields, concatenate will become a long string.

[Luke_C · Accepted solution]

Hi @rockeylearning 

Try using \0  as the delimiter when you configure the output tool. This is the syntax to indicate no delimiter. 

Edited for correct syntax

[caltang]

Perhaps if you can, kindly provide some raw data and we can show you. Otherwise it may not answer your need properly.

[Peachyco]

According to this post, Alteryx string fields can take about 2 billion characters. It's pretty hard to even come close to that limit - concatenating 200 fields with 100 characters each only comes up to 20,000 characters. So, concatenating your string fields and then saving only that concatenated field in the text file might still be a sound solution.

Here's a sample workflow:

Here's the text file:

 

[Peachyco]

@Luke_C 

If I'm not mistaken, the delimiter "\n" is for a new line, which would put each cell in its own row. That's how my CSV is coming out when I use this delimiter.

 

[Luke_C]

Hi @Peachyco you're right! I meant to put \0. Good catch

[Peachyco]

@Luke_C 

Ah, I didn't know about the "\0" delimiter. Learned something new today, thanks! ^_^

And it works even better than my convoluted workflow. Very straightforward:

 

[rockeylearning]

@Luke_C that's worked! Thank you!

[Luke_C]

@rockeylearning Great, happy to help. Remember to mark the solution 😁