Parse txt file

• Jeff Moden

  SSC Guru

  Points: 1000291

  More actions

  May 10, 2022 at 3:20 am

  #4029793

  Bruin wrote:

  Is there some magic that pulls in the file?

  Thx.

  Not really.... just do a BULK INSERT from the file.  I haven't had the time to post it but you should have no issue.  Make a temporarry target table should have a RowNum columns as and identity and a 500 character "DataFromFile" column.  Then just change the code to read from that Temp table instead of the VALUES() clause.

   

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
  "Change is inevitable... change for the better is not".
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  Intro to Tally Tables and Functions