#|# as a delimiter in output tool.

[anuninan07]

Hi all,

I am trying to output .csv / .txt file with #|# as a delimiter, but I am getting the below error. Can anyone please help me to resolve this issue?

Thanks in advance.

[binuacs]

@anuninan07 

[apathetichell]

I do something pretty similar - what I do is transpose everything first and then use a summarize tool to concatenate it (with record id as the group by) basically you create the formatting you need as undelimited text - with the delimiter set in the summarize tool.

The other way is just to output it with a regular delimiter and read it back in and use find/replace to change to your special delimiter and then output as non-delimited. I do the former but the later is probably easier.

[ArtApa · Accepted solution]

Hi @anuninan07 - Here is a possible solution:

You may want to watch the following trainings:

• https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Getting%20...
• https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Excel%20Us...

[anuninan07]

The solution solves my problem

Thank you ArtApa