Alteryx Designer Desktop Discussions

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

outut to txt file with one or more delimiter

Haokun
8 - Asteroid

hi

 

I want to output the source data into @delimitered txt file.

 

below is the source data

 

CountryAmountCodeMethodFile
SG11.50ABCDISDVD
SG12.00ABCDISDVD

 

output should be looking at below in txt file format

SG@11.50@@@@ABCD@@@IS@DVD@@@@@@@
SG@12.00@@@@ABCD@@@IS@DVD@@@@@@@

 

Note, there are multiple columns need to insert @ in the beginning of the string and end of string, so it is not very inefficient to add @ to each column and metadata is quite different from column to column. 

 

I try to use formula to handle those special columns like code and file, "@@@"+[Code]+"@@@", but when i output to txt, I can either choose @ as delimiter and quote output field auto, which my output will be looking something below. which i dont want to have this double quote.

SG@11.50@@"@@@ABCD@@@IS@DVD@"@@@@@@@
SG@12.00@@"@@@ABCD@@@IS@DVD@"@@@@@@@

 

I can't choose @ as delimiter and quote output filed as never, it will give error.

10 REPLIES 10
caltang
17 - Castor
17 - Castor

For reference...

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels