I need to output the results from a query to a pipe delimited file.
I followed these instructions:
Tools--> Options --> Query Results --> Sql Server --> Results to Text. Change output format from Tab Delimited to Custom Delimited. Put a Pipe in the Custom Delimiter Box. Go back to your query select Query --> Results to File. Execute file, Give it a Disk path and a name.
but when I converted the .rpt file to .txt [...also in instructions ...], I don't see any pipes.
You need to open a new query window. Settings changes do not apply for existing query windows.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With