Error in Text Output with a delimiter but no quotes

sdesabhatla — Wed, 11 Mar 2020 20:00:18 GMT

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

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

Re: Error in Text Output with a delimiter but no quotes

DavidP — Thu, 12 Mar 2020 07:25:05 GMT

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.

topic Error in Text Output with a delimiter but no quotes in Dev Space

Error in Text Output with a delimiter but no quotes

Re: Error in Text Output with a delimiter but no quotes