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.
For reference...