+ Reply to Thread
Results 1 to 3 of 3

Extract a part of Text file

  1. #1
    Registered User
    Join Date
    07-09-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Extract a part of Text file

    Hello !!!

    I have a text file that is generated by another program. Below is the snapshot of the file format:

    *********************************** START ****************************************
    SKIRT DATA-MAJOR SIDE
    Z PROFILE
    14.0000 0.1678
    15.0000 0.1591
    16.0000 0.1437
    17.0000 0.1264
    ********************************************************************************
    $-------------- FLARE ENGINE file cards ------------
    $******************* PROFILE # 1 ***************
    SKCORD 1
    ASPF USER
    NASPU 28
    ASPUL -14.00E-03 -15.00E-03 -16.00E-03 -17.00E-03 -18.00E-03 +
    -19.00E-03 -20.00E-03 -21.00E-03 -22.00E-03 -23.00E-03 +
    -24.00E-03 -25.00E-03 -26.00E-03 -27.00E-03 -28.00E-03 +
    -29.00E-03 -30.00E-03 -31.00E-03 -32.00E-03 -33.00E-03 +
    -34.00E-03 -35.00E-03 -36.00E-03 -37.00E-03 -38.00E-03 +
    -39.00E-03 -40.00E-03 -41.00E-03
    ASPUC 0.08391E-03 0.07956E-03 0.07184E-03 0.06320E-03 0.05482E-03 +
    0.04725E-03 0.03975E-03 0.03225E-03 0.02547E-03 0.02045E-03 +
    0.01563E-03 0.01120E-03 0.00749E-03 0.00467E-03 0.00265E-03 +
    0.00126E-03 0.00050E-03 0.00003E-03 0.00000E-03 0.00000E-03 +
    0.00000E-03 0.00000E-03 0.00030E-03 0.00130E-03 0.00550E-03 +
    0.01254E-03 0.02173E-03 0.03337E-03
    $--------------------------------------------------
    ASPFN SAME
    $--------------------------------------------------
    -14.0000 0.0839
    -15.0000 0.0796
    -16.0000 0.0718
    -17.0000 0.0632
    -18.0000 0.0548
    *********************************** END ****************************************

    I would like to extract a part of this file and dump it in a different text file. The part of the file that needs to be extracted starts from the line "SKCORD 1" until the line "ASPFN SAME".
    What would be the easiest way to program this using VBA?

    Thanks

    Paras
    Last edited by parasbshah; 07-15-2011 at 03:03 PM.

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Extract a part of Text file

    Paras,

    Assuming you wanted the text to be put into Cell A1 and down of the activesheet (and only in column A), you can use the following code:
    Please Login or Register  to view this content.


    Hope that helps,
    ~tigeravatar

  3. #3
    Registered User
    Join Date
    07-09-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Extract a part of Text file

    Quote Originally Posted by tigeravatar View Post
    Paras,

    Assuming you wanted the text to be put into Cell A1 and down of the activesheet (and only in column A), you can use the following code:
    Please Login or Register  to view this content.


    Hope that helps,
    ~tigeravatar
    Hi tigeravatar,

    The logic that you gave me worked perfectly. Thanks for that !!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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