Tally OH! An Improved SQL 8K “CSV Splitter” Function

• Jeff Moden

  SSC Guru

  Points: 994284

  March 19, 2019 at 7:26 am

  #2024891

  Eirikur Eiriksson - Tuesday, March 19, 2019 7:18 AM

  Quick question, are there any multi-line entries or can one use the new line bytes as a row delimiter?
  😎

  To whom are you directing that question?

  --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.
  "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
  "Change is inevitable... change for the better is not."
  When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉
  

  ---

  Helpful Links:
  How to post code problems
  Create a Tally Function (fnTally)

• Eirikur Eiriksson

  SSC Guru

  Points: 182344

  March 19, 2019 at 8:52 am

  #2024911

  Jeff Moden - Tuesday, March 19, 2019 7:26 AM

  Eirikur Eiriksson - Tuesday, March 19, 2019 7:18 AM

  Quick question, are there any multi-line entries or can one use the new line bytes as a row delimiter?
  😎

  To whom are you directing that question?

  The OP
  😎

  The spanner in the works is the multi row entries, big difference from handling single row entries 😉

• Jeff Moden

  SSC Guru

  Points: 994284

  March 20, 2019 at 5:33 am

  #2024993

  Eirikur Eiriksson - Tuesday, March 19, 2019 8:52 AM

  Jeff Moden - Tuesday, March 19, 2019 7:26 AM

  Eirikur Eiriksson - Tuesday, March 19, 2019 7:18 AM

  Quick question, are there any multi-line entries or can one use the new line bytes as a row delimiter?
  😎

  To whom are you directing that question?

  The OP
  😎

  The spanner in the works is the multi row entries, big difference from handling single row entries 😉

  Agreed but not much of one if each "record" has the same pattern of multi-line entries.  I do use format files for such a thing if the multi-line entries are consistent.

  --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.
  "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
  "Change is inevitable... change for the better is not."
  When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉
  

  ---

  Helpful Links:
  How to post code problems
  Create a Tally Function (fnTally)