Results 1 to 3 of 3

Thread: Extract string from text file

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Sep 2011
    Posts
    29
    Location

    Extract string from text file

    Hi Friends,

    I need to extract specific numbers from a large text file and copy in excel sheet.
    Total rows will come around 6K.

    I Need to copy the Number after Text String "Item:" in col A & Number after Text String "Nettable Inventory:" in col B.

    Result xl sheet will be like below,

    Item Nettable Inventory
    C110160003 1200
    C117CBB203 0
    C117CBS675 0


    searched in this Forum for code from previous queries and find some but can't make out for my requirement. Your help will be highly appreciated.

    sample .txt file attached.

    With Best Regards
    Attached Files Attached Files

Posting Permissions

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