Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.

Dev Space

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

Error in Text Output with a delimiter but no quotes

sdesabhatla
6 - Meteoroid

Hi, 

 

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

 

sdesabhatla_0-1583955861101.png

 

 

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?

 

Thanks

 

1 REPLY 1
DavidP
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.