Consulting

Results 1 to 3 of 3

Thread: Import text file format to excel difficulty

  1. #1

    Import text file format to excel difficulty

    Hi there, it's been a while since I've been on here, and I come back with a question/problem.

    I am currently trying to set up a text parser for a text file import to excel that is pulled from an old DOS style window screen capture. The issue is that there are a variable amount of these records on any given day, and need to set up some way of importing it.

    I was looking at some other coding on this, but then ran into another issue with some of the lines. There are different pieces of data on some rows.

    I guess what I'm asking for here is some guidance/help in how to get some coding set up for this format honestly.

    I can't put up any specific data (it's proprietary) on this but will just use the example below as a means to try to highlight the situation.

    Row 1 - Field A: <info>
    Row 2 - Field B: <info> Field C: <invfo> Field D: <info>
    Row 3 - Field E: <info>

    There are a lot of blank spaces between each record, and they always start with the same character string.

    Basically I was hoping for a base direction to go running in with this since each row would be a record, and each field would be entered into different columns.

    Thank you in advance for reading this, and any potential suggestions you might have.
    Heaven won't take me.. Hell is afraid I'll take over... adn Purgatory doesn't have a smoking section... I am SO screwed...

  2. #2
    VBAX Mentor
    Joined
    Jul 2012
    Posts
    398
    Location
    attach a sample text file and the desired result xls

  3. #3
    Hi Patel,

    I put together a sample text file for it, but as stated, I cannot give the exact field names in this situation (it's proprietary). But I have attached an excel spreadsheet for the way it needs to be laid out. The fields listed in the original post are the general layout for the text file. It was only allowing me to upload one file.

    Thanks for the response on this.
    Attached Files Attached Files
    Heaven won't take me.. Hell is afraid I'll take over... adn Purgatory doesn't have a smoking section... I am SO screwed...

Posting Permissions

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