outut to txt file with one or more delimiter

[Haokun]

hi

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

below is the source data

Country	Amount	Code	Method	File
SG	11.50	ABCD	IS	DVD
SG	12.00	ABCD	IS	DVD

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.

[Clifford_Coon]

Hi @Haokun ,

Can you give some detail on how you identify the "Special" columns and how many delimiters they requie?

[geraldo]

@Haokun 

Have you changed this option?

[Haokun]

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

[Haokun]

@Clifford_Coon special columns are those need to add more than 1 @ either in front or at the end of string

[Clifford_Coon]

@Haokun   - Is it just a static listing or identified at runtime?

[geraldo]

@Haokun 

sorry, maybe x didn't understand your problem

[Haokun]

@geraldo 

my questions,

1. how to remove the double quote in the txt output, the delimiter is @.

2, the most inefficient way is to manually add @ to each column, is there a better way to handle? i am thinking use multi-field but there are 2 problems, some of the columns are in numeric, some columns need to add more than one @.   

below is the error screenshot.

[Haokun]

the listing is quite static. there is no changes to the headers at the moment just the underlying data will be changed.

[geraldo]

@Haokun 

I didn't understand the criteria for filling in the @ before, after and before after fields.
where or why it is necessary to fill in @ and the delimiter to be @.

has the Mult-Field Formula tool that makes substitutions in several fields of the same format through the reserved word [_CurrentField_]

example: