This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've seen posts (like this one: https://community.alteryx.com/t5/Data-Preparation-Blending/Use-Special-character-in-Formula-tool/td-...) that suggest that in order to retain or export quotation marks as part of a text string, you precede them with a single quote. (So to get "AAA" you use '"AAA"' in your formula.) Only in my instance, I'm attempting to create dynamic content to be written to a batch file, and I need to parse a field name into the string. The juxtaposition of the field name within the quotes I'm commenting seem to be what's causing me problems. Has anyone done this before? What I'm attempting to write to the batch file is this:
@Treyson - I downloaded your sample and the difference between what you've suggested and what I previously tried seems to be feeding the string values through from an input source rather than from within a formula. (I'd previously tried the latter.)
Here's my configuration of my input:
And my formula piecing it together:
And what it produces in my .bat file, which still fails (error code 1):
It seems to want to wrap the entire thing into quotes, and double the quotes I intend to have in place.
I'm going to skip the insertion of quotes and get to the answer.
When you are writing your .bat as a .csv file, Alteryx wants to put quotes around your string. If you change the delimiter to \0 (Null), it won't do that. I'm sorry to hear that you spent a long time on this. I don't know when or where I came across it in my past, but now the torch has been passed and you are the holder of this cup of knowledge.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.