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:
'....FD_FD-SM-S02-' & Timestamp(Today(), 'YYYYMMDD hh:mm:ss') & '.txt'
Well, the "|" character is already in the field. I'm pulling a fully constructed, | delimited record string from an SQL Server view, and just using QV to export to a file.
I'm seeing the the documentation (which took several clicks to get to) that there are file designators like "fix", and "no quote" which I'm testing now.
That pointer on the & connector is helpful.
Thanks for the response.