remove header and blank line from output file querying a DB

• doughora

  Old Hand

  Points: 321

  More actions

  November 3, 2021 at 6:38 pm

  #3947628

  The following script retrieves data from a MS Access database correctly.

  I'd like the output file to NOT have the header and blank line at the beginning of the file.

  Is there a way to suppress these lines?

   

  A second question while I'm asking.   I'm hardcoding the  pipe  delimiter as part of the query.

  Is there options that can be added to have the system put in a pipe delimiter itself while creating the output lines?

  TIA

   

   

  $conn = New-Object Data.Odbc.OdbcConnection

  $conn.ConnectionString= "dsn=GL;"

  $conn.open()

  $result =(new-Object Data.Odbc.OdbcCommand("select CMPIDE & '|' & CRTNOE & '|' & ENAMEE & '|' & DPTIDE & '|' & SEXCDE from a_table WHERE CMPIDE = 'AE';",$conn)).ExecuteReader()

  $table = new-object "System.Data.DataTable"

  $table.Load($result)

  $table | Out-File .\GroupLife-extract.csv

  $conn.close()

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  November 4, 2021 at 7:10 pm

  #3948020

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Ken McKelvey

  SSCoach

  Points: 18766

  More actions

  November 4, 2021 at 9:07 pm

  #3948067

  I have never used powershell with MS Access but I would be inclined to use Export-Csv which has -NoTypeInformation and -Delimiter parameters.