Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Chad Miller Loading Data With Powershell RE: Loading Data With Powershell

  • April 17, 2013 at 4:51 pm

    #1607484

    jcrawf02 (12/16/2008)

    corey lawson (12/15/2008)

    That's a good article, except for a couple of things.

    Why do people still literally use commas as field separators (unless they have to, because the tool/function/utility doesn't support anything else)? Gaaaahhh! The example even uses the field separator parameter...

    And, well, it's PowerShell. I'd rather do this stuff in INTERCAL, but to each their own...

    Of course, BCP does this stuff as well...

    In search of enlightenment, what should we be using as field separators?

    How about it, Corey? What do you people should be using?

    --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)