Home Forums SQL Server 2008 SQL Server 2008 - General Need help to read text file RE: Need help to read text file

  • March 20, 2013 at 12:11 am

    #1598727

    idyana (3/19/2013)

    Hi,

    My text file as attachment ~ AG-Persekutuan-Bln-09-2012.txt

    How to read this file as follows,

    1. Taxpayer data starting in the second row

    2. The 1st TaxPayer read as follows,

    WHOA! Hold the phone and back the privacy truck up! Are these REAL taxpayer numbers? If so, please go back and drop the text file attachment and delete the entries from your post!

    Then find the person that's setting up these files with the information in clear-text and report them! This is SO wrong if these are real.

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