Export to .txt - Quotes Only on Non Dates

[Bonediggler]

Experts -

I have a requirement to export some data in .txt format.  All values must be enclosed by double quotes except for dates.

Is this possible?

[BenMoss]

For sure that's possible but it's not through the standard output configuration.

I've recently done this task on a project for a client so have attached an example of how it can be done.

You have to concat everything together prior to output.

Ben

[ponraj]

Possible to share sample data?

[Bonediggler]

Thanks BenMoss

Unfortunately I cannot download your sample as you created this in a version of Alteryx later than the one I am using.  Can you put the logic you used into words?

I think the basic requirement is to enclose text/string values in quotes.

[BenMoss · Accepted solution]

@Bonediggler here's a tip for you, you can downgrade a .yxzp file using the following process...

1) rename the extension .zip

2) extract the files

3) locate the workflow file and open it in a text editor (such as notepad).

4) In the second line the version is declared. If you have 11.7 then replace 2018.1 with 11.7

5) save the file

6) open in alteryx :)

Ben

[mpatterson]

How do I output to .txt using a .csv file format, showing my string data in quotes and numbers without quotes. The Automatic setting puts none of the data in quotes. -thanks