Fixed Width output

• maraclec

  Ten Centuries

  Points: 1175

  More actions

  June 20, 2002 at 10:31 am

  #158580

  I am trying to export a query out to a fixed width text file. The problems is that if a field has all nulls in it, the DTS "drops" that field and shifts all other text to the left.

  example

  AAAAABBBBBCCCCC

  XXXXXYYYYYZZZZZ

  looks instead like

  AAAAACCCCC

  XXXXXZZZZZ

  when B and Y are null

  Thank you for any help,

  Chuck

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736160

  More actions

  June 20, 2002 at 10:35 am

  #431279

  use isnull() and export spaces (or NULL with trailing spaces).

  Steve Jones

  steve@dkranch.net

• maraclec

  Ten Centuries

  Points: 1175

  More actions

  June 21, 2002 at 3:46 am

  #431329

  The isnull command is working great. Thank you for your help.

  Chuck

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736160

  More actions

  June 21, 2002 at 10:41 am

  #431374

  You are welcome. That's a handy one to keep in mind.

  Steve Jones

  steve@dkranch.net