469,913 Members | 2,107 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,913 developers. It's quick & easy.

Parsing Abstract Files.

I have been charged with Parsing the data from many Abstract files, and then inputing this information into a SQL Database.
The file format is rather unusual and certainly not delimited in any reasonable fashion.
I was wondering if anyone would be able to assist or provide an idea of how I may go about parsing this data for insertion.

The plan is to write a small application in VB that will allow me to run through each text file, and then later search the database based on criteria selected.

Below is an example of the file that we are required to parse and store:

Expand|Select|Wrap|Line Numbers
  1. Title       : Photochemistry of Charge Transfer Excited States
  2. Type        : Award
  3. NSF Org     : CHE 
  4. Latest
  5. Amendment
  6. Date        : February 26,  1992  
  7. File        : a9123000
  9. Award Number: 9123000
  10. Award Instr.: Standard Grant                               
  11. Prgm Manager:                                         
  12.           CHE  DIVISION OF CHEMISTRY                   
  14. Start Date  : April 1,  1992      
  15. Expires     : March 31,  1995      (Estimated)
  16. Expected
  17. Total Amt.  : $143300             (Estimated)
  18. Investigator: Kirk S. Schanze kschanze@chem.ufl.edu  (Principal Investigator current)
  19. Sponsor     : University of Florida
  20.           219 Grinter Hall
  21.           Gainesville, FL  32611    352/392-1582
  23. NSF Program : 1966      SYNTHETIC INORGANIC
  24. Fld Applictn: 0306000   Energy Research & Resources             
  25.               12        Chemistry                               
  26. Program Ref : 
  27. Abstract    :
  28.               This award, from the Inorganic, Bioinorganic and Organo-                       
  29.               metallic Chemistry Program, is for the support of studies of                   
  30.               the photochemistry of excited states of two types of rhenium                   
  31.               complexes in which the rhenium atom has six d-electrons.  In                   
  32.               the first case the complex will contain a bidentate diimine                    
  33.               ligand that serves as an electron acceptor in the excited state                
  34.               and a monodentate ligand that serves as an electron donor in                   
  35.               the excited state, and which is reactive in its electron                       
  36.               deficient form.  Photochemical excitation of these molecules                   
  37.               will generate a ligand-ligand charge transfer (LLCT) excited                   
  38.               state.  Objectives of this phase of the investigation include:                 
  39.               1) delineation of the photochemical reactions that occur                       
  40.               andidentification of reactive intermediates produced via LLCT                  
  41.               excitation, 2) determination of the kinetics of rearrangements                 
  42.               and bond fragmentations of the reactive groups, and 3)                         
  43.               utilization of the rate constants obtained in 2) to determine                  
  44.               the effects of structural and energetic factors on the lifetime                
  45.               of the LLCT excited state.  In the second case, sigma-to-pi                    
  46.               antibonding excitation processes in rhenium(I) complexes that                  
  47.               contain bidentate diimine and alkyl ligands will be examined.                  
  48.               Here the results of bond scission in the excited state will                    
  49.               produce metal- and carbon-based radicals.  A primary objective                 
  50.               of this work is to relate rhenium-carbon bond strength to the                  
  51.               rate of excited state bond fragmentation.                                      
  52.               %%%                                                                            
  53.               Charge transfer in photochemically generated excited states is                 
  54.               a fundamental aspect of biological light energy harvesting                     
  55.               systems.  How charge transfer states are sufficiently                          
  56.               stabilized in biological systems so that productive reactions                  
  57.               occur faster than charge recombination is a mystery that                       
  58.               continues to stimulate exciting research.  Successful emulation                
  59.               of biological systems could mean more efficient utilization of                 
  60.               solar energy for technological purposes; determination of the                  
  61.               reactivity of the excited state in systems such as those to be                 
  62.               examined here may be useful in this regard.  The chemical                      
  63.               systems under study may also be useful as photochemically                      
  64.               activated catalysts for polymerization reactions.
Jul 31 '07 #1
1 1516
200 Expert 100+
The format very much resembles to that of a Lotus Notes text export. If it indeed is, I recommend that you try Goedeke's Notes converter (I like it a lot): http://www.goedeke.net/nte_conv_eng.html
Jul 31 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Gerrit Holl | last post: by
9 posts views Thread by silversurfer2025 | last post: by
7 posts views Thread by jason | last post: by
1 post views Thread by padmagvs | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.