$$Excel-Macros$$ IMPORT FIXED WIDTH TXT FILE TO EXCEL

vivek jain Wed, 07 Apr 2010 21:53:28 -0700


From: vivek jain [mailto:vivek.j...@gmail.com] 
Sent: Saturday, April 03, 2010 8:04 AM
To: 'excel-macros@googlegroups.com'
Cc: 'excel-macros+nore...@googlegroups.com'
Subject: IMPORT FIXED WIDTH TXT FILE TO EXCEL

 

Dear Group Members,

 

I want to import a txt file without any separator except for space of
different lengths. The length of the data field/items  is also not uniform.
Is there any method by which we can convert the fixed width file to comma
separated (CSV) file and then import them to excel.  A Sample file is
enclosed herewith. 

 

Thanks & Regards...

 

cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI)

Vivek Shantilal Jain & Co.

Chartered Accountants

3010 Ram Kumar Arcade,

Chatribari Road, A T Road,

Guwahati-781001

(0361-2603895,9435019908

think_before_print_en

 

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

<<image001.jpg>>

<<image004.jpg>>

þÿ

                 STBTFMFNT FNR 
LRRFGTLBR NVFRDTF LNBN BC

------------------------------------------------------------------------------------------------------------------------------------------

BRBNCH NN - 12234       BRBNCH NBMF -   
    BBBBCCCKK                           
            PBGF NN -     1

------------------------------------------------------------------------------------------------------------------------------------------

SR NN            BC NN   NBMF           
                  NTTSTBNDLNG           
  DRBWLNG            LRRFGTLBRLTY   
BCCRTFD       BCCTMBTN

                                        
                        (RS)            
 PNWFR(RS)           (RS)          
LNTFRFST(RS)     BRBNCH

------------------------------------------------------------------------------------------------------------------------------------------

    1       2133811131-1 LTCKY PRLNTFRS 
                        791711.32       
   419932.32          181788.11         
 77178.47   17177

    2       2138798928-3 M/S LCNM       
                        218144.11       
    87771.11          121373.11         
 31778.71   17177

    3       1181748987-1 MR. PRBNBB 
KTMBR TBLTKDBR              172172.11   
       171721.11           21772.11     
        11.11   17144

    4       1171943182-8 MR. STNLL  DBS 
                        121978.11       
   119419.11           11789.11         
    11.11   17144

    7       1117492783-7 MR. MBHFSWBR  
BNRN                      87179.11      
     73779.11           13111.11        
   1797.17   17177

    8       1119288187-7 MR. STRFSH  
PBTNR                      111731.11    
      187133.11          133898.11      
    12399.84   17177

    7       2137811711-1 MR. BLJNY  
HTJTRL                      119114.11   
        77888.11           73238.11     
      3941.21   17177

    8       1137787772-9 MR. LKRBM  
HTSSBLN                      97118.11   
        88987.11           11341.11     
      3714.37   17177

    9       1138411979-9 MR. DLKSHLT  
NBRBYBN DBS               111181.38     
      79871.38           11491.11       
    8137.18   17177

   11       1137171772-7 MR. RBNJLT  
MNNDBL                      88818.11    
       71877.11           17749.11      
      788.78   17177

   11       1137117141-8 MR. JBDT  
BBLSHYB                      121117.13  
         82729.13           38778.11    
       8978.71   17177

   12       1181119841-8 MR. BBPBN  DBS 
                        141381.11       
    84977.11           77414.11         
 12871.47   17177

   13       2131781879-1 MR. JFHFRTL 
LSLBM SBLKLB               121271.11    
       41991.11           78281.11      
    17183.33   17177

   14       2138192327-4 MR. JBKLR  
HTSSBLN                     118178.11   
        47814.11           71242.11     
     18871.87   17177

   17       2132831129-7 MR. JBHLR  BLL 
                         78749.28       
    88341.28           12419.11         
  1719.42   17177

   18       2133244739-7 MR. FNTSH  BLL 
                         77911.17       
    83798.17           14213.11         
  3123.32   17177

   17       2137872299-7 MR. MD  MNLDTL 
 LSLBM                   78479.11       
    71287.11            7214.11         
  2342.17   17177

   18       2139241789-8 MR. MNNSTR  
RBHMBN                      82274.11    
       78492.11            3782.11      
     2878.81   17177

   19       1132149982-7 MR. STMFSH  
KHBN                        71274.11    
       41378.11            9898.11      
      817.84   17177

   21       1178418177-3 MR. JBLBL 
TDDLN BHMFD`                 111772.11  
        111178.11           29378.11    
       7382.88   17177

   21       1188788881-7 MR. SBTNBM  
SLNGH                      738821.41    
      711118.41           38717.11      
       11.11   11111

   22       1131739294-9 MR. KTSHBL  
BBRTBH                     498871.87    
      473838.87           24834.11      
      818.71   14488

   23       1118742119-2 MRS. DHBNBDB  
BNRB                    1172188.11      
    981132.11           92174.11        
  81418.81   17177

   24       2138472281-7 MR. NBBB  
KTMBR  SBRMBH                744788.11  
        482374.11           82434.11    
      38991.88   17177

   27       2138728398-3 MR. DLGBNTB  
KBLLTB                    432717.11     
     384333.11           48384.11       
   29381.28   17177

   28       1132788323-9  MTNLN  KBLLTB 
                        711177.11       
   479143.11           34134.11         
 38148.14   17177

   27       1138972398-2 MRS. DHTNT  
DFVL                       887118.84    
      818874.84           48432.11      
    18837.74   17177

   28       1148871832-8 MR. NBLLNL KR 
SBRMBH                   838818.83      
    791912.83           47914.11        
  28177.78   17177

   29       1187799174-7 MRS. DLPTY  
DFVL                       447129.37    
      417277.37           31874.11      
    17374.83   17177

   11       1118278337-3  CHRLSTNPHFR  
D. KHNTTLYB              347413.11      
    173233.11          174171.11        
  41173.81   17177

   31       1139788171-4  NLBBRBN  
GNHBLN                       273117.11  
        184347.11           88771.11    
      11329.11   17177

   32       1139491737-8 MR. 
MTSLFMTDDLN  BHMFD                  
71289.11           83171.11            
7119.11             11.11   17177

   33       1137912381-8 MR. BLPTL  
KBTHBR                       78137.11   
        44171.11           31987.11     
        11.11   17177

   34       1137811912-3 MLSS. JBMTNB  
BNRN                      83492.71      
     87882.11           17811.71        
     11.11   17177

   37       1137728112-2 MLSS. BBBLTB  
PBTNWBRY                 117333.11      
     72833.11           32711.11        
     11.11   17177

   38       1139481717-8 MR. JLTFN  
HBZBRLKB                     73782.11   
        38927.11           18837.11     
        11.11   17177

$$Excel-Macros$$ IMPORT FIXED WIDTH TXT FILE TO EXCEL

Reply via email to