+ Reply to Thread
Results 1 to 2 of 2

read value of strings from a text file and make an excel file.

  1. 11-08-2009, 06:05 AM #1
    gashforing is offline
    Registered User
    Join Date
    11-08-2009
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    1

    Lightbulb read value of strings from a text file and make an excel file.

    I have a text file like this:

    INROUTE IN-DEV OUTRTE OUT-DEV ANUM
    TIME EOS SL D T F BTYPE BREC
    TCL TCAP RC TC BSEND

    TATA3I UPDDIV-3983 GTCO1O UPDDIV-37311 2108836867
    1657 3734 13 4 3 5 4 1718044063F
    1 0 2191 0 1201718044063
    PEEL2I SIPD-22179 GTCO1O UPDDIV-37371 7224342324537
    1658 3742 13 4 3 5 4 8801737063682
    1 3 2191 1 1201737063682

    I want make an excel file like this:

    colmn1 colmn2 colmn3 colmn4
    INROUTE OUTRTE ANUM BSEND

    TATA3I GTCO1O 2108836867 1201718044063
    PEEL2I GTCO1O 7224342324537 8801737063682

    NB: same color shows the same value.

    PLz help me.

    //BR,

    Amirul Ahsan
    Bangladesh
    Reply With QuoteRegister To Reply
  2. 11-08-2009, 07:12 AM #2
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: read value of strings from a text file and make an excel file.

    Can you attach a copy of the file itself? It would be useful to know if fields are separated by spaces or tabs and whether there is some sort of rule which indicates which lines to use and which to ignore (e.g. every third line).
    Martin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1