Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!

Error in Text Output with a delimiter but no quotes

6 - Meteoroid



I am trying to generate a txt file that has dynamic SQL Insert statements,The string I am generating in the file is as below


INSERT INTO ABC (A,B,C,D,E,F,G) VALUES ( 'ONBD','C1-BL ','C1 ','CIP','CBL ',' ','1 ' );


With the below setting for Output I get the line enclosed in Double quotes





When I set the 'Quote Output Fields' to 'Never' and had a delimiter  semicolon (; )it will error out 

Error:When Quote Mode is Never, field cannot contain a delimiter character


How do I generate the txt file with no Quotes and end  the line with a semicolon?




16 - Nebula
16 - Nebula

What it's telling you is that in csv mode, you can't leave the quotes out and then have the delimiter that you've chosen, a semicolon, in your data. Since you've already added the semicolon into the data, just choose a space (\s) or newline (\n) as your delimiter or nothing (\0).


You could also choose flat ascii as the output type if you want.