We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How do I get rid of commas between fields in text output (so no delimiter)?

Carl_in_CT
7 - Meteor

Yes, it sounds weird but the request is for txt data output with fields all run together, no commas but retaining the blank fields as blank space.  It seems so simple but none of the simple things I've tried have worked so far, such as data cleansing to remove punctuation (but the commas are not in the fields).  I tried removing the delimiter on the output step but that didn't solve it.  I then tried setting the delimiter to a blank space but it won't let me do that unless I allow quotes which I don't want.  If there were a way to output to a txt file instead of a csv file I would think I would be all set but I can't see how to do that.

 

I'm getting this:

A,   20190101,20190131,5605,00000000000500,                           ,XA11

 

But I need this:

A   2019010120190131560500000000000500                           XA11

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

Set the delimeter to \0 and it should do what you want

Carl_in_CT
7 - Meteor

Perfect, thanks jdunkerly!

Labels
Top Solution Authors