I'm assuming those double quotes are thrown in because of the commas in the text of that field. This data is constructed in other queries to be exported here, and it is delimited by the "|" character, so I do not need the system to include the double quotes.
How do I get rid of this?
Also, how do I get rid of the field name at the top, "Rec_String"?
Here is the store command I'm using:
Store FD_AS into 'C:\Documents\FD_FD-SM-S02-' (txt); // + year(now()) + Month(now()) + Day(now()) + '1201353535' + '.txt'
The stuff beyond the // is where I was trying to add a timestamp to the file name, but that is blowing up. So, that would be a third question, how to concatenate those values onto the text. I'm assuming using the Concat() function. Not sure how to convert numeric to text right now, or if I have to.
Re: Double quotes enclosing some records when exporting to a TXT file
1. To get the text delimited with the pipe character you need to change the (txt) output qualifier to (txt, delim is '|'). Then fields containing commas will not be quoted, but fields containing | will be quoted.
2. I don't know any way in QV to prevent the fieldname. You could call a Windows CMD file using a vbscript (or GnuTools) command to strip the leading row.
3. Its blowing up because you are trying to concatenate the string with the wrong operator. Use & instead of +. I would also simplify this be using Timestamp() to format the date field: