+ Reply to Thread
Results 1 to 3 of 3

Setting up for fixed length field import

  1. #1
    Registered User
    Join Date
    08-19-2009
    Location
    Mobile, AL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Setting up for fixed length field import

    I am importing a text file that has fixed width for sets of data.

    For instance, the first 5 characters are the first field, the next two characters are the second field, and so on.

    Every time I need to bring in a file I have to manually select the field sizes and then add a column to the top of the sheet and paste in the labels.

    How can I set it up so I just import the file?

    Thanks for any help.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Setting up for fixed length field import

    Could you post a sample of the text file - it would be more helpful.

  3. #3
    Registered User
    Join Date
    08-19-2009
    Location
    Mobile, AL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Setting up for fixed length field import

    Here are a few lines. Thanks.

    252148859009044775210000000000000000 0000000000000000700000000 100000000000000000000000000000003
    252148859009024775300000000000000000 0000000000000000600000000 100000000000000000000000000000006
    252148859009022775300000000000000000 0000000000000000400000000 100000000000000000000000000000004

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1