Post reply

what is the format of this text file

  • April 11, 2008 at 7:31 am

    #154276

    hi,

    could you plz tell me what type of text file is this n why the ; is used at the end column.here is the attachment.

    n when importing this file what should i choose in text qualifier,header row limiter,row limiter n column delimiter

    thanks

  • April 11, 2008 at 3:20 pm

    #801730

    garyreeds (4/11/2008)

    hi,

    could you plz tell me what type of text file is this n why the ; is used at the end column.here is the attachment.

    n when importing this file what should i choose in text qualifier,header row limiter,row limiter n column delimiter

    thanks

    The file is a fixed-width file, meaning that you'll need to specify where each field begins and ends. You'll need to check with the source of the file to determine what each column represents.

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply