Formatting SQL output in a text file.

• nathanc

  SSC Veteran

  Points: 239

  More actions

  July 31, 2003 at 3:09 pm

  #80770

  Hi

  I'm running an SQL query and outputting the results to a text file. But the columns appear a little skewed.

  Is there anyway to control the format of the output text document.

  By the way I'm outputting to text file using the OSQL utility.

  Thanks

• mccork

  SSC-Insane

  Points: 22288

  More actions

  July 31, 2003 at 3:19 pm

  #468104

  By default the columns should line up ok. Are there any characters in your output (tabs, crlfs, etc) that could be throwing things out?

  You might to need to employ a combination of REPLACE, LEFT, SUBSTRING (and other functions) together with column aliases.

  If the columns headers are wrapping on output line you may need something like -w500 to increase the output width.

  Cheers,

  - Mark

  
  Cheers,
  - Mark

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  July 31, 2003 at 7:27 pm

  #468123

  Using proportional of fixed spaced fonts when displaying the text files

  Maybe try Courier, even in Notepad.exe